Appen Query in a Form

A

Alyse Brown

I am creating a form with several tables linked and trying to add 2 fields in
multiple tables from one form.

For example, I have NAME and NUMBER in several tables and want to add a new
NAME and NUMBER. If I create a form to add a new NAME and NUMBER, how can I
make sure they are added to several tables?
 
D

Damian S

Hi Alyse,

You shouldn't be saving items to multiple tables in general - you should
have a design that links your tables together via a Primary Key (Unique ID)
and Foreign Key pair.

What exactly are you trying to achieve?

Damian.
 
A

Alyse Brown

Damian,

The NUMBER is the Primary Key in all my tables. I have several tables that
have different information all based on the Primary Key NUMBER. I also have
NAME in every table. Those are the only 2 fields that are the same and they
are linked based on NUMBER.

I am new to access and took this information from multiple sources. Was
thinking I could leave the tables seaparate but am now considering having one
large table. When I add a new field I want to be able to add NUMBER and NAME
to all of the tables.

Not sure if that is any clearer but appreciate your feedback.

Thanks.
 
D

dvorasnell

Will that work in a form as well? If I link via the primary/foreign key, will
that populate the fields in a form/subform??
 
Top