Table Relationship

[Tom Carlsen]

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

 

[Tom Carlsen]

Sorry about the layout - doesn't look at all like the layout I inputted.