Form design with 4 tables = 2*2 parent/child

[herbertioz]

Can someonehelp me with form design with 4 tables.

I have 1 customers table, 1 jobs table, 1 quotes table and 1 products.

Customers->1..many->Jobs

Quotes ->1..many->Products

And all 4 tables is connected with CustomerID.

Do you have some taughts?

 

[llkhoutx]

Form Customers
Relational subform Jobs
Relational subsubform Quotes containing Products

Are you an student in an Introduction to Access course?