Which address to print?
I have a table for my members and a table for their place of work - I am linking Place of work to members so that on my members layout I can assign the same place of work to multiple members one to many -
Under my members layout I am listing a home address
Then I have created a field for Mail goes to (radio button) home/office
I now want to create mailing labels that will display their mailing address for my members based on my selection whether is home or office
How do I tell the database to display address based on my selection?