Access help

[snidy1]

I have five tables with employee names and numbers. Is there a way for me to enter a new name and number only once insted of having to enter it in every table?

 

[snidy1]

Is there no way to do this?

 

[Traire]

Why do you have 5 identical tables? Why not just use one?

 

[EagleKeeper]

Have a table with the employee names & numbers and the other tables just link/use the number.

Otherwise you will have to do some programming to actually take the user input and stuff the info into all tables.

 

[snidy1]

All of the tables have Emp name & number, but are differant, some have hiredates, etc. I have them all linked, but when I add a new employee, it doesn't show up on all of them. Just the one I add it to.
Sorry, I'm just a beginer in access

 

[Thyme]

If it's just the columns that are different, can you just use one table and select the columns that you need when you need them?

 

[JonTom]

I don't like to make unhelpful posts but...

It sounds like your db isn't well thought out from the start. Rather than bandaid it, you may want to look into the basics of relational db designs, and start over. Of course this may seem like a big investment, but it will likely be worth it in the long run.

</speaking from experience>

 

[KLin]

Originally posted by: snidy1
All of the tables have Emp name & number, but are differant, some have hiredates, etc. I have them all linked, but when I add a new employee, it doesn't show up on all of them. Just the one I add it to.
Sorry, I'm just a beginer in access

You should definitely consider buying a book or 2 on access. You can easily consolidate all of that information from 5 tables into 1 or maybe 2 tables.

 

[brandonbull]

when you set the table relationships up you can enable cascading updates and deletes

 

[EagleKeeper]

Originally posted by: snidy1
All of the tables have Emp name & number, but are differant, some have hiredates, etc. I have them all linked, but when I add a new employee, it doesn't show up on all of them. Just the one I add it to.
Sorry, I'm just a beginer in access

go down to your local library and get "Access For Dummys" as a starting point.

Then get a book that contains more indepth info on Access. They may have such an animal in the library or go to the local bookstore/computer store and pick it up for $20+.

spend a week-end looking through it and getting ideas on how to fix your problem.

You need to also make a copy of the DB and run the analysis tool against the copy to see what Access itself thinks ofthe situation.

 

[dderolph]

Have you tried using Queries? Based on relationships you set up between the various tables, you can generate a Query based on your tables. You can save Queries and then re-generate them as your tables get updated. That might be an option/solution for you.

 

[BFG10K]

Only one table should have employee data and the rest should just be linked with employee codes.