Need calculation for showing specific address
I'm setting up a ClientTable with clients who may be associated with numerous addresses (Residence, MBusiness, WBusiness, etc.) listed in related AddressTable matched by ClientID.
I need to send publications to specified clients at specified address - sometimes a client should receive publication at more than one address. PublicationTable will show clients to receive current publication with SendTo specifying which address to use from AssociationChoices (Residence, MBusiness, WBusiness, etc.) in AddressTable for related ClientID.
What is the simplest calculation for pulling up the address from AddressTable based on SendTo in PublicationTable?