How to use multiple addresses?

[Mingan]

Hi. I'm new to the forum, hi! I searched through and couldn't find an answer to the following question, so any help would be greatly appreciated (I've just finished reading the O'Reily book, and still couldn't figure this out).

I have a table called Employees. It uses fields from another table called Companies to enter their address. This is useful for when we need to mail multiple employees from the same company - we don't need to type there address in over and over. However some employees have different addresses, say an employee that works from home.

I have created another set of fields to enter in their addresses, but I can not figure out a way to make a button that would read something like, "Use Company address or personal home address". Your suggestions welcome. Thanks!

[Vaughan]

Creat another field with, say, radio buttins to allow selection of company or home address. Then create a calculation field that selects the address fields, based on the radio button selected. Use this calc field in your letters and labels etc.

[Mingan]

Thanks, this is a great suggestion. I'm new to calculations, but I'm sure I will be able to figure it out - if however, anyone has something similiar to post as an example, it would be helpful. Thanks again.