single field link to multiple tables

  • Thread starter Thread starter sherry
  • Start date Start date
S

sherry

I have a fairly complex database containing many areas of
interest connected only by a single project number. I am
trying to figure out a way to type in the project number
for new entries only once and have that project number
link to other tables without having to retype it in. Can
this be done? I was looking at possibly creating a multi-
page form containing each area that would then send data
back to each table when filled in. I am learning Access
as I go, I'm wondering if I made the table(s) too
separated or if I should have created one large table
containing all of the main information and break it down
from there. Any help would be greatly appreciated!

Thank you in advance!
 
Are you familiar with creating relationships? There is a
way to do this and you might want to search for more info
via your help wizard. :)
 
If your tables are properly related, you'll enter information about the
project in ONE place, and all other information would link to that.

Before you get too far along, I would encourage you to brush up on your
understanding of relational database theory and design ... there are several
good books on the subject, one of which is "Database Design for Mere
Mortals" ... Google on "relational database design books" or something
simlar for more titles. Also, you
 
Back
Top