Tables and forms

[Frodo]

I was wondering I am using
5 tables to hold information about people fly fishing in rivers.
tables are

Table 1. Name of the person
Table 2. Date,place,number
Table 3. Salmon.trout.snag.spawn
Table 4. Bait and weather condition

I use forms to enter information into the tables, which work good.

But when I take a look at entered information in the tables, I cant see that the person that entered hes/here name first what data belongs to that person from the other tables, its like ther link between the data in the tables is missing or something like that.

I was wondering how to fix this, and what it is called.
Would be great to get some feedback takes me to long to search for it in the access book.
regards
Frodo from Iceland

 

[GohDiamond]

Sounds like you are using Separate data-entry Forms for each Table?

There has to be a relationship between all the tables. For example, if table 1 is to relate to table 2, 3 & 4 there must be a common key. Table 1 would have the PrimaryKey and that Primary Key would be used as a ForeignKey in all the other tables.

Table 1. UserID, Name of the person
Table 2. T2RecordID, UserID, Date, place, number
Table 3. T3RecordID, UserID, Salmon, Trout, Snag, Spawn
Table 4. T4RecordID, UserID, Bait and weather condition

I hope that helps,

Goh

 

[The_Doc_Man]

Useful reading for you would be to Google-search the word "NORMALIZATION" and then mull over that for a while. Ignore anything except recognizable .COM and .EDU sites for the articles. This will help you know why you keep some things separate and others together.

Also search this forum and the Access help files for topics on keywords such as JOIN, INNER JOIN, junction table, many-to-many, etc.