Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are new to access and setting up an internal project. We have separate
tables for each user (around 30 users). The data which each user inputs gets
stored in their respective tables. Now, we need a Master Table that contains
or pulls up the data from each individual table and provides us a
consolidated table.

Please let me know how to go about this or if there is a much simpler way to
get this done.

Thank You,
Venugopal
 
Whoaaa,

Why do you have separate tables?

Just build one table for the records. Make a field for "UserID" and store
the UserID for the person who added the record.

Proper database design would never dictate that you have to go in and change
your entire table structure everytime you have personnel turnover. That's
just crazy.

Rick B
 
First of all, there is a much simpler way. You don't want a table for every
user, that is your main problem. You want to have ONE table (master table)
with fields such as UserID (primary key), UserName, User Address....etc etc
and then base a query on that with all those fields from the table. Then you
can create a form that is controlled by that query and then enter the
people's names on that form, one by one. All those people, after you enter
them onto the form, are stored in the MAIN Table - the Master.

If I have confused you in any way...please let me know!
MN
 
Hi...

Thanks for the prompt reply.

We tried different tables for different users to prevent overwriting the
records. Is there any way to prevent it if we use a single Master Table?
 
Hi Rick,

Thanks for the prompt reply.

The reason why we tried different tables for different users is to prevent
overwriting the records.

Is there any way to prevent overwriting, if we use a single Master Table?

Thanks once again...

Venu
 
Hi Rick,

Thanks for the prompt reply.

The reason why we tried different tables for different users is to prevent
overwriting the records.

Is there any way to prevent overwriting, if we use a single Master Table?

Thanks once again...

Venu
 
How would a record get overwritten?

If ten users are adding a record, then ten records will be written.

Rick B
 
WHen you have one master table, you don't overwrite the records at all. A
"key" identifies each person and that is prevented. Those records are unique
to that person.
 
Venugopal said:
We are new to access and setting up an internal project. We have separate
tables for each user (around 30 users). The data which each user inputs gets
stored in their respective tables. Now, we need a Master Table that contains
or pulls up the data from each individual table and provides us a
consolidated table.
Click to expand...


As everyone will tell you, one table with a userid field.

If your concern is for security in that you don't want one
user to see the data for other users, then filter the
records displsyed in a form by the userid field. (You have
no intention of letting users access/see the raw data
tables, right?)
 
Why would the users need separate tables?

On Tue, 8 Mar 2005 07:21:05 -0800, Venugopal Chakkoth <Venugopal
 
Back
Top