K
Kork
My database has two tables (Customer & Address) with the 'one-to-many'
relationship, meaning: one customer record has two addresses "BillTo" and
"ShipTo". A customer record keeps IDs of both addresses.
I need a form that gives the user an ability to enter customer info as well
as both addresses. In addition, if I've found a customer record the same form
will have the customer record as well as both addresses.
It looks like that one alternative is to implement this in form/subform
technique . The main form (Customer Form) has to have two subforms ("BillTo
Address" and "ShipTo Address") both of which directly related to the main
form. Keep in mind that the form relationship is not nested but hierarchical.
I did not find the way how to implement the hierarchical relationship between
forms.
Are there any other alternatives?
relationship, meaning: one customer record has two addresses "BillTo" and
"ShipTo". A customer record keeps IDs of both addresses.
I need a form that gives the user an ability to enter customer info as well
as both addresses. In addition, if I've found a customer record the same form
will have the customer record as well as both addresses.
It looks like that one alternative is to implement this in form/subform
technique . The main form (Customer Form) has to have two subforms ("BillTo
Address" and "ShipTo Address") both of which directly related to the main
form. Keep in mind that the form relationship is not nested but hierarchical.
I did not find the way how to implement the hierarchical relationship between
forms.
Are there any other alternatives?