Table Design

[Bryan Hughes]

Hello,

I have a Case File management db. There can be multiple clients in each
case file. Each case file has a primary contact. Each client also can have
separate addresses and address history. It is possible that the Primary
Contact is not a client.

How should set this up that if the Primary Contact is a client if the
address is changed in the client area the primary contact is updated, or if
the address is changed in the primary contact then the address is changed in
the client area.

-TFTH
Bryan

 

[Sharkbyte]

Set up an indicator, from either table, that identifies a client as a Primary
Contact. Then use an If Statement to update the other address record.

Sharkbyte