Ok, here's my problem...... I have a contacts table which includes, ID, FirstName, LastName, Category, Region, Date of Birth, etc. Then i have a Personal Details Table which lists their home addresses and a business table that lists their business addresses.

The problem is.... some of our contacts have their home addresses as preferred mailing addresses, others have their business addresses. I have a yes/no field in the table that...