I would say the first part of this - as with all databases - is to get the table structure correct.

Here you have one file number and the possibility of many dependants so we have immediately identified a one to many relationship. Ergo we need two tables for this:

tblJobs
JobID (autonumber - primary key)
JobName
etc.

tblSubjobs
SubjobID (Autonumber - primary key)
JobID (foreign key to tblJobs)
Subjob etc..

Can you enlighten me as to what you have?


It may, even, be prudent to introduce a third table in order to make this a many-to-many relationship which - inevitable - may be best.