How can I automatically enter repeating data from one table to ano

[Sally]

Hi I am a novice so if you can help please do. I have set up a database and
have a range of tables established for each of my categories and they seem to
be working well. How do I get the database to automatically fill in
repeating data (ie names) from one table to the next so I don't have to keep
retyping? Hope this makes sense.
Please help in simple English.
Here's hoping!!!
Sally

 

[Douglas J. Steele]

In a properly designed relational database system, you shouldn't have the
same data in multiple tables. You may want to read up on Database
Normalization. Jeff Conrad has some good resources on this topic at
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#DatabaseDesign101

 

[John W. Vinson]

Hi I am a novice so if you can help please do. I have set up a database and
have a range of tables established for each of my categories and they seem to
be working well. How do I get the database to automatically fill in
repeating data (ie names) from one table to the next so I don't have to keep
retyping? Hope this makes sense.
Please help in simple English.
Here's hoping!!!
Sally

You don't!

Relational databases use the "Grandmother's Pantry Principle": "A place - ONE
place! - for everything, everything in its place".

You should have a table for People (I'm assuming that you mean people's
names); the name of a person should exist in that table, *and noplace else*!

The other tables should have a PersonID, as a link to the Primary Key of the
people table. Every table should have a Primary Key (Access tries to suggest
that this must be an Autonumber; that's often a good choice but not essential.

If you need to see the name in conjunction with data from another table, you
create a Query joining the People table to the other table by the PersonID;
choose the name data from the People table, and the other data from the other
table.

You may want to look at some of these resources, especially the tutorials
toward the end; Crystal's video might be a good start.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Larry Linson]

You don't!

Relational databases use the "Grandmother's Pantry
Principle": "A place - ONE place! - for everything,
everything in its place".

John... you left out the word "should" between "databases" and "use" -- all
too often, I see people using Access with the "Fibber McGee and Molly's
Closet Principle". Eventually they get the same result as the sound effects
on that ancient radio show when they try to find something. <GRIN>

Larry

 

[Bob Quintal]

John... you left out the word "should" between "databases" and
"use" -- all too often, I see people using Access with the "Fibber
McGee and Molly's Closet Principle". Eventually they get the same
result as the sound effects on that ancient radio show when they
try to find something. <GRIN>

Larry

No he did not leave out the word "should". When a database has data in
multiple places, it is not 'relational' but just spreadsheet on
steroids,

 

[John W. Vinson]

John... you left out the word "should" between "databases" and "use" -- all
too often, I see people using Access with the "Fibber McGee and Molly's
Closet Principle". Eventually they get the same result as the sound effects
on that ancient radio show when they try to find something. <GRIN>

Larry, now that John Viescas isn't hanging around here any more, you and I may
be the only ones around here OLD ENOUGH to remember Fibber McGee and Molly!

<g>

 

[David W. Fenton]

Larry, now that John Viescas isn't hanging around here any more,
you and I may be the only ones around here OLD ENOUGH to remember
Fibber McGee and Molly!

I'm ancient, too!

Well, I never heard it on the radio, but it was a common reference
for my father and grandmother.