You have a Contacts table with ContactID and an Addresses table with a ContactID and an AddressID, and they are currently related by ContactID, giving you a list of related addresses for the current Contact. And you want to select an Address (probably from the address portal on the Contact record) and specify that it is the default (current) address?
There are a few ways to do this. Many people would just put a flag field called PrimaryAddress in Addresses with a 1 in it. Some people might put a PrimaryAddressID in the Addresses table and insert the AddressID again in it. I would instead place a PrimaryAddress field in Contacts and join that to a new Addresses table occurrence called PrimaryAddress:
Contacts::primaryAddressID = PrimaryAddress::AddressID
Your primary address for this contact is now always available. For selection, attach a button in your Addresses portal with:
Set Field [ Contacts::primaryAddressID ; Addresses::AddressID ]
To identify your current primary address in your portal of addresses, you can attach conditional formatting (example, yellow fill) to the fields with:
addresses::AddressID = Contcts::primary
UPDATE: Well I don't know how to stop that :P issue through the post. It should be a colon and capital 'P'. If anyone knows how to fix it, I would like to know - it makes it difficult to read.
UPDATE: Well I don't know how to stop that :P issue through the post. It should be a colon and capital 'P'. If anyone knows how to fix it, I would like to know
thank you very much