G
Guest
I have a database where I want to show the billing
addresses for each address that someone may have. This is
set up as a one (address) to many (billing addresses)
relationship. Addresses are also linked to Tax Ids as a 1
(tax id) to Many (addresses) relationship. I've got the
form set up so that there is an address subform in a form
based on tax ids. I've also nested the billing addresses
subform into another addresses subform (to create the link
between tax id and billing addresses). I want this to
display so that if I'm on a certain tax id record, all of
their addresses display. Then by clicking on an address,
the corresponding billing addresses display. Currently,
all I get is that the billing addresses for each address
under the selected tax id will display for me to scroll
through in the datasheet. Any help with this is greatly
appreciated.
addresses for each address that someone may have. This is
set up as a one (address) to many (billing addresses)
relationship. Addresses are also linked to Tax Ids as a 1
(tax id) to Many (addresses) relationship. I've got the
form set up so that there is an address subform in a form
based on tax ids. I've also nested the billing addresses
subform into another addresses subform (to create the link
between tax id and billing addresses). I want this to
display so that if I'm on a certain tax id record, all of
their addresses display. Then by clicking on an address,
the corresponding billing addresses display. Currently,
all I get is that the billing addresses for each address
under the selected tax id will display for me to scroll
through in the datasheet. Any help with this is greatly
appreciated.