Technical information
Error number -2147217900
Error description [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'OrderNO'.
URL /AspPro/Allocations_list.asp
SQL query select [No1A], [No1B], [No2], [No3], [No5], [Mic1], [Mic2], [SC], [Verm], [PK], [Vapin], [BCade], [Calc], [Wet3], [Wet4], [Traded], [GenMaint], [Building], [Training], [FLT], [CleanWaste], [PPE], [HealtSafety], [Capital], [Sundries], [Water], [Electric], [Gas], [Diesel], [RawMat], [OrderNO] From [scheme].[Allocations] where [OrderNO] = 567 OrderNO
Have highlighted what I think is the problem but have no idea how to remove the field name from the code .
Error occurs during a master / detail lookup
