HI I am hoping you can help me. I seem to have a metal block and can’t remember how to do this.
I have a form, with a combobox (on the form header) that is linked to a table called suppliers.
The table has the suppliers Name and IDcode and other information. When the user selects a supplier by name using the combobox.
I want to get the supplier! IDcode And Link to in the list box in the main form to only show records from the table stocklist that have the same idcode.
Using the IDcode in the suppliers table to link to the IDcode in the stocklist.
I have a relationship between the tables using the supplier idcode field in the suppliers tables joined to the IDcode in the stocklist table.
But I seem to be brain dead. As I can not get the list box to link to the idcode. It’s driving me mad. Thanks in advance for any help given
mIke
I have a form, with a combobox (on the form header) that is linked to a table called suppliers.
The table has the suppliers Name and IDcode and other information. When the user selects a supplier by name using the combobox.
I want to get the supplier! IDcode And Link to in the list box in the main form to only show records from the table stocklist that have the same idcode.
Using the IDcode in the suppliers table to link to the IDcode in the stocklist.
I have a relationship between the tables using the supplier idcode field in the suppliers tables joined to the IDcode in the stocklist table.
But I seem to be brain dead. As I can not get the list box to link to the idcode. It’s driving me mad. Thanks in advance for any help given
mIke