J
Jane
Not sure if I've got a design problem or I've just not got the skills to
code this seemingly simple function.
I've got three tables tblSuppliers, tblProduct and tblSupplierProducts.
From the Suppliers Form, I'd like the user to select a range of products the
supplier stocks from a combo box (could be 10 products or more per supplier)
.. The SuppliersID and ProductsID would be stored in tblSupplierProducts (is
this right?). It would be useful if tblProducts is updated if the user adds
a product not already in the list. Ideally the user should be able to view,
edit and add to this list through a command button on the main form.
I'm wrestling with this one a bit. I've got the subform working in
principle but if the user adds another product, even if it exists in the
tblProducts, it adds another record to the table.
Hope this makes some sense to someone out there!
code this seemingly simple function.
I've got three tables tblSuppliers, tblProduct and tblSupplierProducts.
From the Suppliers Form, I'd like the user to select a range of products the
supplier stocks from a combo box (could be 10 products or more per supplier)
.. The SuppliersID and ProductsID would be stored in tblSupplierProducts (is
this right?). It would be useful if tblProducts is updated if the user adds
a product not already in the list. Ideally the user should be able to view,
edit and add to this list through a command button on the main form.
I'm wrestling with this one a bit. I've got the subform working in
principle but if the user adds another product, even if it exists in the
tblProducts, it adds another record to the table.
Hope this makes some sense to someone out there!