Table Relationships

  • Thread starter Thread starter Gary
  • Start date Start date
G

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)
 
I have a Fee Table with Contract #, Company Name, and many
$ fees for services (no primary key)....
Click to expand...

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


B Wishes


Tim F
 
Back
Top