Adding additional data

A

Allan Skyner

I am fairly new to Access and perhaps I'm not seeing the woods for the
trees.. yet!

I have built a table of supplier's data that is populated from a single form
with each record having an autonumber identifier of SupplierID and I have
another table of products with an identifier of ProductID.
I have created a seperate table to store the SupplierID and the product ID
so as to record the products supplied by each supplier, one supplier can
supply many products and the same product can be bought from many suppliers.

I have created a seperate form linked to a table of products and can select
the right product from a combo box, my problem is that I can't see how to
link this product data to the SupplierID.

Please can anyone help as I don't think I've quite got an Access brain yet?
 
A

Arvin Meyer [MVP]

Build a subform using the intersection table (or a query based on it) as a
recordsource. Put that subform in the supplier's form. Link the fields on
SupplierID.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Allan Skyner said:
I am fairly new to Access and perhaps I'm not seeing the woods for the
trees.. yet!

I have built a table of supplier's data that is populated from a single form
with each record having an autonumber identifier of SupplierID and I have
another table of products with an identifier of ProductID.
I have created a seperate table to store the SupplierID and the product ID
so as to record the products supplied by each supplier, one supplier can
supply many products and the same product can be bought from many suppliers.

I have created a seperate form linked to a table of products and can select
the right product from a combo box, my problem is that I can't see how to
link this product data to the SupplierID.

Please can anyone help as I don't think I've quite got an Access brain
yet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top