Primary Address

[benk]

I have a contact manager db and I only want to display one address per person. Currently I have to run a script attached to a primary checkbox looping and setting any related address to non-primary. Is there a trick to doing this using a one-to-one relationship? Or another basic way without a script?

Basically, if a person has three addresses and I set one to primary(1) all the others should be set to non-primary(0)

[Mikhail Edoshin]

Store the identifier of the primary address in a field in the Contact table.

[benk]

Hey Mikhail,

This will work, and am using this technique in other places where addresses are hardcoded to display a certain type of address (ie work address in the business section)...as the primary address (ie...work, school, etc) is not hard coded I was hoping to not have to use a script to copy or set the field.

Essentially this address can be any type of address, it just has a second identifier as being the primary address. The tricky part is when adding a new address or changing the primary address I want a bullet-proof way to make sure there is only one address set as the primary (preferrably without scripting)

Edited August 19, 2006 by Guest

[bruceR]

There can only be one if you follow the suggestion.