Linking Table Clients to Table Policies

[george]

Hi to all,

I've been pondering about this question for quite some
time and I would really appreciate some help.

I have my clients table, tblClients, and my insurance
policies table, tblPolicies.

Each policy is assigned one and only one ContractedPerson,
and is also assigned one or more InsuredPerson(s). Both
ContractedPerson and InsuredPerson are considered clients.
The ContractedPerson can be the same as the InsuredPerson
or different.

What is the best way to link the two tables?

Thanks in advance, george

 

[Sirocco]

I would have the following 2 tables related 1 to 1: Policies, and the
primary client, who holds the contract. I would have a 3rd table, for
"additional insured", related to the client table 1-to-many, with the client
table on the 1 side, since each primary client can have several additional
insured. Alternatively, perhaps more simply, you could have all the
insured in the client table, and simply indicate the primary contract holder
with a yes/no checkbox, but several of the insured could have this checkbox
checked by accident, which would obviously lead to confusion.