Relationship Problems.....

[David]

Hi,

I have the following Tables:

JS_Customer
JS_Job
JS_Product
JS_Pack

The layout:
Every Customer can have MANY Jobs
Every Job can have only ONE Product
Every Product can have MANY Packing Parts

I can use the form wizard fine with JS_Customer & JS_Job (1 to many)
I can use the form wizard fine with JS_Product & JS_Pack (1 to many)
I seem to have problems getting the forms to work with the (1 to 1)
relationship between JS_Job & JS_Product.

How can I link the 2 forms each with their own sub-form to each other:

I can use the form wizard fine with JS_Customer & JS_Job (1 to many)
I can use the form wizard fine with JS_Product & JS_Pack (1 to many)

I need to link these 2 forms so they work together.



_______________ _____

I want to have a form, where I can select a customer from a Combo,
Enter some Job data, then Select a Product from a Combo, which will
then diplay the specific list of packing elements to that product.


How hard can this be......



Thanks in advance

David