0 Replies Latest reply on Feb 27, 2014 10:39 AM by bk1

    Need calculation for showing specific address

    bk1

      Title

      Need calculation for showing specific address

      Post

           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?