--Adds "Asset Project" as a supported column for imports from the General Import - Assets Template.xls  ; this was tested such that ir was successful for the column in excel to  contain either the ID of the projecct or the Name of the project.
Use Users_mdb 

IF NOT EXISTS (SELECT * FROM [dbo].[tblFieldMap_ImpRule] WHERE nID=4 AND tInternalFieldName='Allocated_to_Project')
BEGIN 
	INSERT [dbo].[tblFieldMap_ImpRule] ([nID], [tInternalFieldName], [tInternalTableName], [nInternalDSID], [tExternalFieldName], [nValueTableID], [tExternalFieldFormat], [bForeignKey], [bSyncOnlyNewRecord], [nCVLookupMode])
	VALUES (4, N'Allocated_to_Project', N'tblDts', 32, N'Asset Project', 50, NULL, 0, 0, NULL)
END

