populate fields from data in another table

[Guest]

Hi
I am new to creating databases and am having trouble with populating fields
from one table to another.The db has 4 tables and 4 forms. It doesn't contain
any combo boxes or list boxes.

The fields are
ID number
Surname
Initials
DOB, etc

I need to fill in a registration form and then fill in other forms, I don't
want to have to repeatedly put in Surname, etc in each form.

This is a simple data entry db.

I would greately appreciate any assistance that you could provide. Not sure
what information you require but will supply what ever I can.

kind regards

Grinch

 

[John W. Vinson]

Hi
I am new to creating databases and am having trouble with populating fields
from one table to another.The db has 4 tables and 4 forms. It doesn't contain
any combo boxes or list boxes.

The fields are
ID number
Surname
Initials
DOB, etc

I need to fill in a registration form and then fill in other forms, I don't
want to have to repeatedly put in Surname, etc in each form.

This is a simple data entry db.

I would greately appreciate any assistance that you could provide. Not sure
what information you require but will supply what ever I can.

kind regards

Grinch

If you are trying to store the Surname and other information
redundantly in a second table - DON'T. You're missing the whole point
of how relational databases work! They use the "Grandmother's Pantry
Principle" - "a place - ONE place! for everything, everything in its
place".

The surname and other personal info should be stored ONLY in the
"people" table. Other tables should have ONLY the ID field. If you
want to see the name onscreen on another form... ummm... use the tools
that Access provides to do so, i.e. a Combo Box. This can be bound to
the ID number field but display the person's name, for example.

John W. Vinson [MVP]