Forms and Subforms and Subforms and Subforms (1 Viewer)

[welshpunk]

Hi Clever Ones

I have a customer form which I fill using a combo and this works ok. Within the form I have a Jobs subform which basically only holds
JobID*
CustomerID
CarID

Both CustomerID and CarID are foreign keys

I also have a jobDetails Subform. This is the line data for the job and includes
JobID CustomerID CarID PartID Qty UnitPrice LineTotal

I have another form which totals up the subtotal, works out VAT and a grandtotal.

All the forms are linked together by CustomerID

All works well until I have a customer who has had two jobs completed. This shows up in the Jobs Subform as a second record.

What I would like to do is when I move to the second record in the Jobs Subform - I would like the JobDetails and JobTotals to change also.

Any ideas welcome

Regards

 

[MarkK]

You are working with jobs, job details, and job totals on a form called Customer.
What you need is a form called Job. Make it so when you click on a job on the customer form, the Job form opens to the job you clicked. Then your JobDetails subform should be a child form of the Job form.
hth

 

[welshpunk]

Thank you very much

Regards