Sub Datasheet problem

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

Guest

I adding vehicle maintenance records into my database. I have created a table
for each maintenance record call Invoice. it contains an index,vehicle id,
date, mileage, provider, etc. Then I created another table for the details of
the maintenance. It contains the catagory of service performed, service
performed, part cost, labor cost. I need a sub table because each invoice has
several types of service performed. I am having trouble linking up the fields
as niether table has matching data. Can anyone give me a suggestion. I do not
want to have to type in a record number for each new subcatagory performed.
Thank you Jason
 
I adding vehicle maintenance records into my database. I have created a table
for each maintenance record call Invoice. it contains an index,vehicle id,
date, mileage, provider, etc. Then I created another table for the details of
the maintenance. It contains the catagory of service performed, service
performed, part cost, labor cost. I need a sub table because each invoice has
several types of service performed. I am having trouble linking up the fields
as niether table has matching data. Can anyone give me a suggestion. I do not
want to have to type in a record number for each new subcatagory performed.
Thank you Jason
Click to expand...

Well... to start with...

Use table datasheets ONLY FOR DEBUGGING. They are not designed for
production work, and are very limited.

Instead, use a Form (for the vehicle info) and a Subform for the
service provided. The subform's table must contain a VehicleID field,
or an InvoiceID field, as a foreign key (otherwise of course there's
no way to know WHICH car was being maintained!) This linking field
would be used as the master/child link field on the Subform.

John W. Vinson[MVP]
 
Back
Top