Okay, forget that, I have set up all of it manually, now I am attempting to update the database with an ADOCommand component, I have managed to update all of the fields except the one associated with the lookup combo box.
The basic look of the code is:
ADOCommand1.CommandText:='UPDATE Stock...
I can't use the form wizard to set up the data entry form as the database format I'm using is apparently incompatible, I have no idea how to set it up so that it works manually.
Okay, I have an Access database connected to an ADO dbgrid in delphi through ADO connections. there are a few problems I'm having with it.
Firstly, I have a lookup table for one of my columns set up in access, it's for a supplierID column, it gets the supplier ID number and the supplier name...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.