Okay, so I belive I've done the right thing and setup some relational tables as follows (feel free to correct me anywhere along the way).
As a snippet, I've got:
tblSupplier - with a supplier_id, supplier_name, etc.
tblManufacturer -with a manufacturer_id, manufacturer_name, etc.
Then I have a relation table to pull the two together:
tblDistributes - with manufacturer_id and supplier_id
The idea being that Manufacturer X is distributed by Supplier Y - I believe that's the right way to set this up, again, correct me if I'm wrong!
So I have a form to edit the fields in tblManufacturer, and I can get a combobox to lookup the keys and values from tblSupplier - but then how do I write those values into the tblDistributes table? Access seems to only really want to write into a field in the manufacturer table (judging by the wizards....).
I appreciate this may be in the wrong section, as it's semi to do with design and semi to do with forms - so apologies for that.
Any assistance would be greatly appreciated.
As a snippet, I've got:
tblSupplier - with a supplier_id, supplier_name, etc.
tblManufacturer -with a manufacturer_id, manufacturer_name, etc.
Then I have a relation table to pull the two together:
tblDistributes - with manufacturer_id and supplier_id
The idea being that Manufacturer X is distributed by Supplier Y - I believe that's the right way to set this up, again, correct me if I'm wrong!
So I have a form to edit the fields in tblManufacturer, and I can get a combobox to lookup the keys and values from tblSupplier - but then how do I write those values into the tblDistributes table? Access seems to only really want to write into a field in the manufacturer table (judging by the wizards....).
I appreciate this may be in the wrong section, as it's semi to do with design and semi to do with forms - so apologies for that.
Any assistance would be greatly appreciated.
