two tables with same information

K

Kelly

I have a simple data base (#1)wtih names, address, etc... I need another
simple data base (#2) that I can just put in check boxes for attendance (all
i need to import is first & last name and probably the ID#). How do I merge
or take the names from data base #1 and bring it into database #2. As I add
names to database #1 which is weekly, I want database #2 to automatically
update also.
 
R

Rick B

Why would you have multiple databases? Sounds like just two separate
functions in the same file. I'd just build a form for each task if it were
me.


There are ways to link the tables between files if that is what you really
wnat, but I can't see any advantages to it.

Post back more details if you need more help.

Rick B
 
S

Sprinks

Kelly,

This is something you do not want to do.

Each table in a relational database should describe different attributes of
a single thing. When you design a related table, include only a foreign key
in its definition, in this case, the IDNumber. You DO NOT need nor WANT any
name fields in your second table. Maintain the names in one place.

You can easily *display* the name, their address, and/or any other field on
your input form, however, by basing your form on a query, or using a combo
box whose rows are records from your People table, and which includes the
columns you'd like to display. Then you can use the Column property of the
combo box to display another column in a textbox. The property is
zero-based--the first column is 0, the second 1, etc.

For example, to display a PhoneNumber, the 3rd column of a combo box, set
the textbox' Control Source to:

=YourComboBox.Column(2)

Hope that helps.
Sprinks
 
Top