Wonder if any of u can help.
I am working on D5 Enterprise, using ADO components to connect and manipulate an Access 2000 database.
Setup is as follows:
FormA has DBGrid with datasource, adoconnection, adotable components looking at an Access table.
FormB has DBGrid with datasource, adoconnection, adotable components looking at the related table.
One of the fields is a foreign key to another table, so I set up a lookup list using a calculated lookup field. I set the app up so that if the user currently has focus on this lookup field on FormA, then by pressing a command button they call another form (FormB) to edit the contents of the related table. When the user closes this form they are taken back to FormA and the dbgrid should update to reflect the users changes -- the problem is its not updating. It does if I close the app and re open it, but this is obviously not what I want. I've tried refreshes, requerys, closing the connection and reopening it, all fail. Am I:
a) not attacking this in the correct way,
b) addressing a bug,
c) missing something
any ideas please.