Updating Data in Multiple Tables
Thanks for that - I'll read up on how to link then I should be ok
--
JohnM
"John Spencer" wrote:
Possible? Yes. Good idea, almost certainly NO.
If for some reason you really need to do this
AND you have some way to associate a record in table 1 with a corresponding
record in table 2
AND you do the data entry through the forms
you can use a VBA routine in the after update event of the form's to update or
create the necessary data in the other table. THIS IS NOT A GOOD IDEA in
almost every case.
You would need to write some VBA routines to do this.
Depending on your situation a much better approach would be to create another
table that holds the common information and link that to your two tables. OR
keep the data in one of your current tables and link the other table to the
first table. That way you would be updating only one table.
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
JohnM wrote:
Could any one advise me please
I have two tables that contain some fields that are the same.
I have also two forms to enter data into the seperate tables
Is it possible to enter data into a table using the relevant form that shall
also update the same fields in the other table and vice versa
Thanks
.
|