Parent Child Relationship

[Guru86]

I am currently building a database and it has to deal with job numbers. The primary key between the three databases is the job number, but on of the databases keeps track of the expenses that hit that job. so my question is how do I include all of the invoices sepratley but still have the job number asociated.

[Dal Jeanis]

The invoice table should allow each invoice to have its own record, with a primary autokey, with the job number as one of the fields on the record. Use the primary key (JobID) of the job record to link the associated records on each table.

tblJobs
JobID     autokey
JobName   text

tblInvoices
InvID     autokey
JobID     foreign key to Job
(then all the invoice details)

If you need to have some specially formatted JobCode that people will use/input to access the file, then put it on tblJobs, but keep it separate from the autokey field, and it will save you lots of trouble in the long run.