My Relationships

[benheaven]

Hello,

Just want to know what i should change in terms of my relationships or what's wrong with them?

Any Advice Would Be Great

Attached File Below

Thanks
Ben

 

[Liv Manto]

FIrst, your first two tables are incorrectly link.

Second, I dont want to go further for fear of going nuts over your "relationship"

 

[Pat Hartman]

I'm going to take that a little further and say that all your tables are improperly linked.
1. ID is a poor choice for a name. Rename ALL the ID fields to something meaningful such as PaymentID, QtyID, etc.
2. Make sure that the foreign keys are defined as long integer because they need to hold the autonumber value, NOT the text value.
3. Use the same name for the foreign key and primary key names to make it easier to see the relationships by just looking at the table layout.