Problem Table structure & Relationships

[MrAllen]

Hi
I'm fairly new to this and have run across a problem with my first database.
I'm attempting to digitize our local Burial Records stretching from 1891 to 2014.
I've created a couple of Tables containing the the data I have but I'm having problems creating a relationship.
The problem is that the fields have either duplicate data or contain null records.
The Table Analyser is therefor of no use. The only fields that I could use are the Primary Key Autonumbered ones, which I believe is a bad idea for relationships.
I attach images of the fields & hope that someone has some suggestions.

 

[jdraw]

Since this is your first database, my suggestion is for you to work through this tutorial. You will learn concepts of database and table design and relationships, if you work through the tutorial. But, the important thing, after having completed the tutorial, is for you to write a clear description of what you are try to do -- in plain English --similar to the problem description provided in the tutorial. It will help you tremendously if you have a clear description of the things involved that you can reference and adjust/refine as you add detail.
Do you have a list of things(questions/reports..) you want to get from this database? That will tell you a lot about what must be in/go in the database. Make a plan; build some test data; apply what you learned in the tutorial to your situation;create a data model; make sure you can get the answers/reports you want from the data; then build the database.

Good luck.

 

[RainLover]

Auto Number is fine to use as the primary key. Your Foreign key would then be a Long Integer

Age should be DOB as this can be calculated each time you use it.

Is there a Table for Survivor or some other person who may be in charge, If so I think you can relate the other tables to it.

However JDraw has given you a tutorial to follow. I would suggest that you do that.