Form Problem

[EssexRob]

On a form i have clients details with a subform displaying jobs related to the clients.

The jobs subform is in a tabular format, obviously so i can see all the data of jobs for the client.

The job however requires more information (such as specification etc) which i would like to be able to click on the job and then display the rest of the details on another form.

So! The problem is when i click on the job i want it to display just the relavant job and not every single job.

Thanks for any help

 

[MStef]

Hello Rob!

I suggest you, make a 3 tables, tbl "CLIENT", tbl "JOB", tbl "SPECIFICATION".
Make a MAIN FORM on tbl CLIENT (single form), SUBFORM on tbl JOB (single form), and SubSUBFORM on tbl SPECIFICATION (continuous form).