One field ONLY...?


Howdy,

We have a table with addresses. One individual might have
multiple addresses.

We have a field to assign certain characteristics to a
particular address, for example, send brochures to address
"A", or invoices to address "B".

For certain characteristics, it is important that only one
of the addresses be so marked. For example, we might want to
send invoices to one, and only one address.

What is a sensible way to set this up (with code, or
otherwise.)

I strongly suspect that I am ignoring something very simple
here, but just can't see my way though.

Thanks for any help on this,
--
Kenneth

If you email... Please remove the "SPAMLESS."
.

Relevant Pages
Loading