Multiple Tables - how, where do I start?

J

jake

Hi guys,
I have a databse program I trying to develope for my funeral home. I
recently discovered that I should break up my one large table and
normalize it into the several seperate tables. They are listed below.

Vitals (Master_key primary Key)background info)
Death_Info ( death info - place time etc..)
Service (service place,times, minister etc...)
Cemetery (cemetery name, place, lot number etc...)
NOK (Next of Kin, address, phone etc...)
FH (funeral home)
Merchandise (items selected by family, casket,urn,vault etc...)

the following tables are not used on every case,
Cremation (cremation info: crematory, permit signer etc.)
Coroner (Coroner name, reason, etc...)
Military (military rank, war, va marker, flag)


I getting confused as how to link all of the above tables - so that I
can use them with a form.
1) What is the proper way to set up each table in regard to primary
keys?
2) What is the proper way to then set up thier relationships?
3) What do I then do next? the query or the form, or c something else?

Thanks for your help, Jake
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table design qeustion 4
New to Access - Where do i start? 4
How do I auto update 11 tables with same primary keys thru a form? 3
How Do I create a Macro that Creates Linked External tables? 1
How do I query multiple Tables with difernet Primary Keys 2
How do I set up sync of outlook between two computers (on a netwo. 1
Complex Database - How do I accomplish the Goal? 8
How Do I Join Multiple Tables into a Single Table? 3

Top