I have this view that has fields from 2 tables:
BATCH.BANUMBER and PRODUCT.PRNAME
These 2 tables are linked by BATCH.BAPRID = PRODUCT.PRID
I created the view and use it on a form as the source for a Combo Box.
This works fine but..
The combo box will not reflect the current status of the batch or product tables. For instance if I ADD a new BATCH record and link it to a product, there should now be a new record in the combo dropdown. But despite doing a cmbCombo.REQUERY this is not so. The same with a BROWSE of the view as also when a record is deleted or edited.
IS there a way to make the view update with changes made to either PRODUCT or BATCH table so the combobox always displays the current data?
I have tried everything possible in the view designer but cannot get this to work.
Bernatd