B
bmkmd
How do I set up these relationships? I think I have most of them but...
I need several different reports using some of the same information, but
only one record at a time. I have six tables
In order to get a query to limit the records I need to see essentially all
the tables, which means I need the relationships to work with the tables.
The needed tables as I see it are as follows:
1) The injured worker: name, address, ssn etc.
2) The employer: name, address etc.
3) The Insurance Company info
4) The Attorneys (one table for two attorneys, applicant and
defense...control buttons?)
5) Workers Compensation Appeals Board by location
6) Examination with fields for date scheduled and perfomed and when report
sent.
6) A junction table, the Claims table with its own primary key ID, with
foreign keys from Injured Worker, Employer, Insurance Company, Attorneys,
WCAB and Examination tables.
The claims table allows me several one to many relationships centered on the
Claim, with access to each table for a Form, queries and the various reports.
But I get stuck figuring out the following:
6) The claims adjuster table: the adjuster works with one injured worker per
claim, and with one insurance company per claim. But the adjuster may have
many injured workers, and the insurance company may have many adjusters.
And also, the injured worker may have several claims in sequence with a
diffierent employer and inusrance company, and the injured worker may have a
claim with two or more insurance companies for the same claim (might be over
time where employer switched inusrances)
Help.
What are the one to many relationships which include the adjuster? The
insurance company(ies)
Is there a many to many relationship for adjuster with foreign keys from the
Insurer and the Claimant?
I need several different reports using some of the same information, but
only one record at a time. I have six tables
In order to get a query to limit the records I need to see essentially all
the tables, which means I need the relationships to work with the tables.
The needed tables as I see it are as follows:
1) The injured worker: name, address, ssn etc.
2) The employer: name, address etc.
3) The Insurance Company info
4) The Attorneys (one table for two attorneys, applicant and
defense...control buttons?)
5) Workers Compensation Appeals Board by location
6) Examination with fields for date scheduled and perfomed and when report
sent.
6) A junction table, the Claims table with its own primary key ID, with
foreign keys from Injured Worker, Employer, Insurance Company, Attorneys,
WCAB and Examination tables.
The claims table allows me several one to many relationships centered on the
Claim, with access to each table for a Form, queries and the various reports.
But I get stuck figuring out the following:
6) The claims adjuster table: the adjuster works with one injured worker per
claim, and with one insurance company per claim. But the adjuster may have
many injured workers, and the insurance company may have many adjusters.
And also, the injured worker may have several claims in sequence with a
diffierent employer and inusrance company, and the injured worker may have a
claim with two or more insurance companies for the same claim (might be over
time where employer switched inusrances)
Help.
What are the one to many relationships which include the adjuster? The
insurance company(ies)
Is there a many to many relationship for adjuster with foreign keys from the
Insurer and the Claimant?