defining relationships

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

Guest

Hi.
I'm trying to design a database for a customer inventory system.
Some of the customers will have tier pricing and some will have their own specifying pricing.
Pricing will be determined based on the category, desc, thickness and measure of the product. I created separate tables for each category. I created another table which will use 1 field from each of those description tables to create a productID.

When I try to set up the relationships for these 5 tables, I'm having trouble.

In addition, my product table has a 2 field primary key. Individually the fields can have duplicates but as a key not. However, when I try to create relationships, I can't enforce referential integrity because I don't have a unique index. How do I handle this?

Thanks.
 
Megan

If you've already tried joining the relationship on more than one field (if
appropriate), another option would be to use arbitrary primary keys, via an
Autonumber field. You can show the relationship by including a foreign key
in each related table, said foreign key to hold the "parent" table's primary
key value.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top