Hi,
probably a stupid question but: I have 2 lisboxes on this form. One is based on the table tblSuppliers and has 2 columns: SupplierId and SupplierName. Only SupplierName is visible.
The second lisbox is based on the table tblProducts and has 4 columns: ProductId, ProductName, SupplierId, Price.
Now I only want to make sure that when I choose a certain product in the second listbox, the supplier gets selected in the first listbox. I(m not sure which property I should use here and how.
Thanks in advance,
dj.
probably a stupid question but: I have 2 lisboxes on this form. One is based on the table tblSuppliers and has 2 columns: SupplierId and SupplierName. Only SupplierName is visible.
The second lisbox is based on the table tblProducts and has 4 columns: ProductId, ProductName, SupplierId, Price.
Now I only want to make sure that when I choose a certain product in the second listbox, the supplier gets selected in the first listbox. I(m not sure which property I should use here and how.
Thanks in advance,
dj.