Linking Records & Viewing

[spock1971]

Before I spend an age trying to get this to work I thought I'd consult some experts.

I have a main data table for recording all possible insurance claims against a company. What I want to do is create say 2 incidents but link them in some way. i.e. One of our drivers had a car accident (1 claim against our motor policy), but then the driver of the other car sues us(1 claim against our public liability).

I can create 2 seperate records and maybe have a field to highlight parent/child reference numbers, but is there anyway I could allow the user to click a button and see the related records simultaneously?

Cheers

 

[aleb]

If you have in a table some field which will bear the same code to identify the case then everything is possible. Ex.
#| Code| Division| Address1|
-------------------------------------
4 BUJO Pre TX
5 BULA Wif TX
2 SMJO Cit AL
3 SMPA Gov VN
6 SMSA Cit WA
7 SMSA Cit NB
1 SMSM Cit Min

As you can see the "division" column has the same code for number of records
Well in this case go "insert","subdatasheet"
Select the same table, select the same field as parent and child, click Ok.

Now click on the + sign and you will see the related records, only one problem the table is referencing to itself you can drill down 8 levels seeing the same information

 

[wazz]

it sounds like a table issue. it sounds like your tables should be something like:
one incident can result in many claims.

tblIncident
IncidentID (PK)
IncidentDate
IncidentPlace
etc.

tblClaim
ClaimID (PK)
IncidentID (FK)
Type (FK) (links to tblType that holds data such as 'Motor Policy', 'Public Liability', etc.)