relastionships

D

doob

im trying to understand relationships .....

i have 3 tables ultimately for a purchase order processing database but
just for testing currently.

tblProducts
ProductID (PK)
ProductDesc
tblPOnumber
PONumber (PK)
PODate
tblPOdetails
POLineID (PK - Autonumber)
PONumber
ProductID

in the third table ... would PONumber and ProductID be the related
fields to the same field in the first two tables, both as many to 1 as
there can be many instances of both in tblPOdetails but only 1 instance
of each in their respective tables .... is that right?
 

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

Similar Threads

Unable to display values in 2nd list box from 1st list box selection 2
Relationship change to one to one 2
Order Entry type form to add to three tables 12
primary key - concatenated or autonumber? 6
Trouble Creating Form 5
Complex Dynamic Table Data Entry Form 2
Tables and Relationships Help! 3
dependent lookup / query 1

Top