By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Relationship Problems.....

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.