waterdamage
Registered User.
- Local time
- Today, 22:37
- Joined
- Jan 12, 2007
- Messages
- 18
I have a test db that I have been able to build a
Customer Table
Estimate Table
Items Table
I have successfully made a Form called customers that has a sub Form called estimates linked to it.
This works perfectly displaying the customer and the linked estimate information. I have a Form called Items and when I double click the customer ID field in the sub Form it runs a macro and brings up the Form Items.
My question is how do I get the Items Form to display the customer ID and estimate ID lifted from the estimate sub form.
Customer Table
Estimate Table
Items Table
I have successfully made a Form called customers that has a sub Form called estimates linked to it.
This works perfectly displaying the customer and the linked estimate information. I have a Form called Items and when I double click the customer ID field in the sub Form it runs a macro and brings up the Form Items.
My question is how do I get the Items Form to display the customer ID and estimate ID lifted from the estimate sub form.
