USE [Purchases&Agreements02_def]
GO


IF NOT EXISTS ( SELECT nID FROM [dbo].[tblDtsFields]  WHERE nID=958)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (958, N'tblDts', 32, N'Purchased_for_Project', 1, 103, 50, N'Purchased for Project', 0, 0, N'Project', 16, 1, 1, 1, NULL, 1, 1, NULL, N'Project', NULL, N'cbo_958_Purchased_for_Project', 32, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO


IF NOT EXISTS ( SELECT nID FROM [dbo].[tblDtsFields]  WHERE nID=959)
	INSERT [dbo].[tblDtsFields] ([nID], [tTableName], [nTableDSType], [tName], [nDataViewID], [nDataType], [nDataSize], [tCaption], [fChoiceOrder], [fRequired], [tFieldValuesTable], [nValueTableDSType], [fEnabled], [fKeepHistory], [fCanQueryBy], [tDestinationTab], [fEditable], [fVisible], [nRelatedField], [tLabelCaption], [tAliasSourceTable], [tBoundControlName], [nDestinationTabID], [tWhere], [fIncludeInDefaultReports], [nRelationshipType], [nContainerType], [nControlType], [tValueTableIDFld], [tValueTableNameFld], [nRevisionNumber], [tOrigCaption]) 
	VALUES (959, N'tblDts', 32, N'License_Server', 1, 103, 50, N'License Server', 0, 0, N'Computer', 16, 1, 1, 1, NULL, 1, 1, NULL, N'License Server', NULL, N'cbo_959_License_Server', 32, NULL, 0, -1, 1, NULL, NULL, NULL, 2, NULL)
GO

-- Use Organizations choice table
UPDATE [dbo].[tblDtsFields] 
	SET [tFieldValuesTable] = 'Organization',
	tWhere=''
	WHERE nID=883
	
GO





