I have a form for entering Purchase Orders that is comprised of a main form with PO Header info and a subform where the line item detail of the PO is entered.
The main form and subform are linked by the PO# field being the Link Master & the Link Child. The data from the main form goes to one table and the subform data goes to another table.
My problem is when you call up a PO# already saved and want to change the PO# the link is broken and only the revised PO# is saved in the main form table. Teh original data showing in the subform disappears.
When you look in the underlying tables you find the original PO# record in the subform data table but the main form data table contains both the old PO# record and the new PO# record file.
How can I maintain the link during the revision of the PO#?
Thanks for any help.
The main form and subform are linked by the PO# field being the Link Master & the Link Child. The data from the main form goes to one table and the subform data goes to another table.
My problem is when you call up a PO# already saved and want to change the PO# the link is broken and only the revised PO# is saved in the main form table. Teh original data showing in the subform disappears.
When you look in the underlying tables you find the original PO# record in the subform data table but the main form data table contains both the old PO# record and the new PO# record file.
How can I maintain the link during the revision of the PO#?
Thanks for any help.