I am working on changes to my contact database. In the database there is a table for the Organisations and one for the Contacts.
What I need to add is an option to have an alternate address for an alternate address. So I added two field to the contact table.
AlternateAddressID (Which Links to the new address if there is one, default is 0)
UseAlternateAddress (Boolean which the user specifies to use the alternate address or not)
I though this was fine but then I though when I am doing my normal joins from the Contact to Organisation tables i want the alternate address to join (AlternateAddressID) if the user has selected this other wise join to the orginal address (OrgID). Is there a way to join like this or is there a better way to do this.