muti tables, muti forms question

  • Thread starter Scott Vreyens via AccessMonster.com
  • Start date
S

Scott Vreyens via AccessMonster.com

I have multipule tables and forms, my problem is I do not know how to make
info from one form to show up on a different form with a majority of the same
info.
 
J

John Vinson

I have multipule tables and forms, my problem is I do not know how to make
info from one form to show up on a different form with a majority of the same
info.
Click to expand...

Well... it sounds like you're making the rather common mistake of
assuming that Forms can store data. They can't.

A Form is JUST A WINDOW. It displays data that's stored in a Table;
asking for data "on one form to show up on a different form" is almost
meaningless.

Simply base each Form on a Table or (very often) a Query selecting
data from one or more tables, the data which you want to see on that
form.

John W. Vinson[MVP]
 
S

Scott Vreyens via AccessMonster.com

Sorry I guess that I didn't make my problem totally clear, I do have two
tables that use some of the same info, Like first, and last name. what I was
wanting to do was If I type the last name in form A that access would fill in
the form with the first name and any other info that is used in both tables
Ei I have a personnel form and a training form with respective tables. how do
I go about linking both tables. or do I just need to do a query from both
tables?
 
J

John Vinson

Sorry I guess that I didn't make my problem totally clear, I do have two
tables that use some of the same info, Like first, and last name.
Click to expand...

Then your tables are NOT correctly normalized.
what I was
wanting to do was If I type the last name in form A that access would fill in
the form with the first name and any other info that is used in both tables
Ei I have a personnel form and a training form with respective tables. how do
I go about linking both tables. or do I just need to do a query from both
tables?
Click to expand...

By correctly normalizing your table structure, for instance:

People
PersonID
LastName
FirstName
<other information about the person>

Training
PersonID
<information about the training that this person received>

The last name and first name should exist in the People table AND
NOPLACE ELSE. Storing it redundantly in the training table is a very
bad idea, and is not necessary.

Typically you would use a Subform for the training, using the unique
PersonID as the master/child link field.

John W. Vinson[MVP]
 
Top