Hi,
I have a RA database with 3 tables. The master table is the CustomerInfo Table and associated with that is a subtable called RAUnitsReceived. Everytime I create a RA record in the custumerinfo table and then want to add sub records associated with it I get a error in the sub table called RAUnitsReceived. Everything seems to work fine, but the error occurs when I click on "back to list" after adding records. I can quite see why it would do this. I have zipped the file and sent it to customersupport too. Please let me know if you can help. Thanks
Steve
steve@networkcar.com
here is the error I get:
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Missing ), ], or Item in query expression '([RAUnitsReturned].[NetworkcarRA#]='54321''.
/RAUnitsReturned_list.asp, line 891
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Page:
GET /RAUnitsReturned_list.asp
Time:
Friday, January 06, 2006, 10:19:47 AM
More information:
Microsoft Support