General question about tables

[ruse]

Here is what I have:
1. A list of publications that are frequently revised.
2. A list of company owned manuals and instructions that are created from the first list that need to be changed to reflect their revisions.

It goes a little further, but what I basically need is to create a DB with a form for entering/ editing the publications and the ability to print a report detailing all the company owned manuals and instructions that must be changed to reflect a revision to a publication they reference.

I am pretty much a novice, having only created a few elementary DBs, and was wondering if anyone had ideas as to how to link the tables since the second table will need to link to many records in the first.

 

[cuok]

HI RUSE,

Did you tryed the templates that comes with ACCESS?
Open Access program and choose: templates then try if you see somthing close to your needs.


good luck

 

[MelissaBerrett]

Ruse,
Linking tables is done through relationships. It sounds like you are going to have a one-to-many relationship between two tables, going from your second table to the first. Once you have determined your primary and secondary key for your tables, go to Tools > relationships. Add your two tables in, and simply drag the field that has the relationship to the other table in it. Good Luck

 

[ruse]

Thank you both. I will be trying it in the next few days. I was thinking I was goingto have to list all the references in the second table, but after reading I should be able to link them, no? Well thanks again.