Form Field input passing to Parent and Child tables??

[jsmer]

Can anyone offer help. I have a form that is using a Parent and child table. It is an order entry form. The parent is customer based. The child table is for holding the ordered line items. The key in Parent Table is Customer # and the link to child is Item #. The child's key is item # and the customer table has multiple entries for item #'s ordered. The child table also needs to have customer number on each record for certain reports use. The customer # field has referential integrity with the Parent key. The problem is that Customer number is entered once on the form and does not flow to the child table records of which four or five are written per Customer order entry. Thanks for any help you can offer.
Jim

 

[Langley]

Your tables should look like this if I understand the problem:

Parent:

Customer number*
other stuff...

Child:

Customer number*
Item number*
other stuff...

They should be linked on the form's data model and every time you insert a record in the child table the parent's customer number will be inserted.

Mac

"Do not delve too deeply in the arts of your enemy and so become ensnared by them"

langley_mckelvy@cd4.co.harris.tx.us