Marking addresses as preferred

Hello,

Here's my structure:

tblClients
*ClientID
....

tblAddresses
*AddressID
....

tblClientAddresses
*ClientAddressID
ClientID
AddressID
Preferred (y/n)

I want to make sure that every client has no more than one preferred
address. I've identified those with more than one preferred, and it's a
small enough number that I can clean that up manually.

But what about clients who have one or more addresses, but none are marked
as preferred? How can I make sure that each unique client in
tblClientAddresses has at least one (and preferably only one) of their
addresses marked as Preferred?

Many thanks in advance!!

Matthew


.

Relevant Pages

  • Re: Saving client addresses
    ... when you create tblClientAddresses, you'll need to remove the address fields ... indicate which, of several addresses for a single client, is the *current* ... that's a simple solution at the table/query level, ... > We need to save the addresses of our clients when we send out letters ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Marking addresses as preferred
    ... FROM tblClients LEFT JOIN tblClientAddresses ... University of Maryland Baltimore County ... I want to make sure that every client has no more than one preferred ...
    (microsoft.public.access.queries)
  • Re: Marking addresses as preferred
    ... What are we missing?? ... FROM tblClients LEFT JOIN tblClientAddresses ... I want to make sure that every client has no more than one preferred ...
    (microsoft.public.access.queries)
  • Re: Marking addresses as preferred
    ... an alternate approach might be to use a Priority field instead of the Preferred field ... That way, the user can specify the not only the #1 address for the client, but other preferred addresses as well. ... I want to make sure that every client has no more than one preferred address. ... How can I make sure that each unique client in tblClientAddresses has at least one of their addresses marked as Preferred? ...
    (microsoft.public.access.queries)
  • Re: Marking addresses as preferred
    ... On my main Client form, I have a subform that shows that client's preferred ... tblClientAddresses has at least one of their ...
    (microsoft.public.access.queries)
Loading