Tables

  • Thread starter Thread starter Carl Johnman
  • Start date Start date
C

Carl Johnman

If a user enters data on a form can that data be stored in
2 seperate tables at the same time? Please help and thanks
in advance.

Carl
 
Assuming you mean the same data in mirrored tables you could do it one of
two ways. Have an unbound form that opens two tables and populates the
record in both tables from the fields on the form. Or, a bound form that
opens one table and writes the record to the second table in an unbound
method.

GL.
 
It seldom makes sense to store the same data in two separate tables. What
are you actually trying to achieve?

TC
 
As per TC's question, I'd also like to hear the reason why you need to do
this. This is the second post I've seen asking the same exact question.

Entering/adding data to 2 or more tables via a form can certainly be done.
But think of other maintenance you have to do, what happens when a the user
updates a record? deletes a record? Seems to me it's a lot of headache to
always remember to keep the 2 tables in sync at all times... one glitch and
they go out of sync!

HTH,
Immanuel Sibero
 
Back
Top