Table Relationships

[Gary]

I have a Fee Table with Contract #, Company Name, and many
$ fees for services (no primary key)....I have a Service
Code table with many services by code (both text code &
Number code) Autonumber primary key....
I have a form with combo boxes to select Service codes by
catagory - Now I want to match up the Service code
selected in each combo box by the Fee which is different
per Contract # and Company Name and produce a budget
report or form - this may be a many to many relationship ?

Gary
(e-mail address removed)

 

[Tim Ferguson]

I have a Fee Table with Contract #, Company Name, and many
$ fees for services (no primary key)....

Rule one: If it doesn't have a primary key it's not a table.


B Wishes


Tim F