View Single Post
  #2  
Old May 10th, 2010, 09:55 AM posted to microsoft.public.access.gettingstarted
xps35
external usenet poster
 
Posts: 22
Default Updating Data in Multiple Tables

=?Utf-8?B?Sm9obk0=?= 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

--
JohnM


I think that will be possible.

But........
I think it would be better to avoid situations where you store the same
data in two tables.
So consider to re-design your database.

--
Groeten,

Peter
http://access.xps350.com