Hello. I have been trying to figure this out, but no matter how much I research it or how many attempts I make, I can't figure it out. What I'm trying to do is work with 2 tables. The first table is very similar to the other 2 tables, that only difference would be that it includes the customer name and PO. There are other fields in there besides that. These fields aren't identical to the fields in the other two tables. But they are not customer related. They're order related. Just different processes of the order.
I'd like to create whatever relationships that need to be created. I'd tell you all that I tried, but if I did this would be a really long post. And then I would like to create a form based off of table1. Use that as the parent form. Make child forms out of the other 2 forms. Then make the form much bigger and then put twp child forms in the main form.
I'd like to have it so that as I enter info into table1, I can then enter data into the child forms and have them connected to the parent form.
Can someone help me out with this?
If necessary here's a little bit of what the forms look like field-wise (the fields in red are primary keys)
Form1 Form2 Form3
CustomerId ProcessID InspectionID
CustomerName DateRequired InspectedMeasure
PONumber SpecialREquirements AcceptedYes
ConditionIntact OperatorSignature AcceptedNo
ConditionDamaged SetupSignOff InspectedCut
Thanks in advance.
I'd like to create whatever relationships that need to be created. I'd tell you all that I tried, but if I did this would be a really long post. And then I would like to create a form based off of table1. Use that as the parent form. Make child forms out of the other 2 forms. Then make the form much bigger and then put twp child forms in the main form.
I'd like to have it so that as I enter info into table1, I can then enter data into the child forms and have them connected to the parent form.
Can someone help me out with this?
If necessary here's a little bit of what the forms look like field-wise (the fields in red are primary keys)
Form1 Form2 Form3
CustomerId ProcessID InspectionID
CustomerName DateRequired InspectedMeasure
PONumber SpecialREquirements AcceptedYes
ConditionIntact OperatorSignature AcceptedNo
ConditionDamaged SetupSignOff InspectedCut
Thanks in advance.