Table Relationship

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would appreciate some help on releationship and integrity.
What shoul my relationships be?

tblPurchaser tblLots
tblModels
pk-purchaserid - autonumber pk-lotID - Number pk - modelID -
Autonumber
lotID - number lotnumber - number Project -
text
Name - text laddress - text
modelName - text
modelID -number

Purchasers don't always select a lot when first entered.
Purchaser can select the lot at any time but only one purchaser per lot no
duplicates
A lot can have only one model and may not always have a purchaser
models can be on many different lots but only one model per lot
A lot does not intitally get a model

I am confused on the relationships I should create. Thanks for any help
Does any
 

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

tables and relationships 4
Tables and Relationships Help! 3
multiple level relationships 1
Consolidating duplicate child records 1
relationships/ tables 2
Primary and foreign keys, database setup, and "Cannot add or change" error 2
Help with table structure for manufacturing production counts 4
Getting a subform to automatically display info from a table 6

Back
Top