multiple items to a claim

[prostheticHead]

I have to redo the company I work for’s insurance program and they want it done in access. I’ve hit a big snag though. Not only are my Access skills very rusty. But also I have a very complicated task here!

I would need a customer table an insurer table and an adjuster table. These tables would link to a Claim table. In the claim table I need to make it show the items that the person is going to get with there insurance money by getting details from a table with all of the information for the items.

But how do I make it so you can add more then one item to the claim?

Some people may have 1 item to replace some people may have 20 items.

Hopefully someone understands what I mean here

Thanks Heaps
Ashley Colman

 

[trucktime]

Insurance

You may need another table, let's call it ClaimDetails.
The Claims table will have a unique key field, probably a claim number.
Then you create the ClaimsDetail table, including a claimnumber field.

These two tables then can be linked on claimnumber, in a one-to-many relationship. Meaning every claim can have virtually unlimited linked records in the ClaimDetail table.

In the Claim table you record the general info about the claim, in the ClaimDetail you put the specific items, amounts and what other info you need.

You can easily establish and maintain the relationship by building a form for the Claims table with a subform for the details.

It is best to bind the forms to queries, which will allow you to pull only that infro from the table that you need.

One last advice, plan your mdb carefully before you actually start building tables, queries and forms. It may save you considerable time later.

Good Luck.

 

[prostheticHead]

Thanks heaps!

 

[trucktime]

Insurance

You're welcome.

 

[prostheticHead]

dose this look right? the insurance Table is pritty big though

 

[trucktime]

Insurance

It looks good to me, although I don't know of course what some fields are for.
Don't worry about the Insurance Table, it's not big at all.

You may want to ad 3 fields to the tblClients, a Title field (Mr. Mrs. etc.), an Email field and perhaps a Date field so you can track when they first became your client. Just a thought.

 

[prostheticHead]

exlent!

and thanks for the good ideas! defently want a date feild there to see when they joined!

Thanks Heaps again!