sharing data

[Art Vandaley]

Hi,

Is it possible to send data into two tables which have exactly same fields
in A2007 by using only one form? Thx.

 

[Guest]

Yes, its possible, by using an unbound form and inserting rows into the table
with code, but it goes completely against the fundamental principles of the
database relational model. There is almost certainly a better way of
achieving the underlying objective. If you'd care to expand on the reasons
for wanting to do this we can probably advise further.

Ken Sheridan
Stafford, England

 

[Guest]

Why you need to do that? Two tables with same records? :O
The easiest way is to edit one table and then:
1) Delete all existing records in the second table.
2) Insert all records from the first table to the second one (use INSERT
query).

I just don't understand the reason...

Vlado

 

[Joseph Meehan]

That sounds like a bad idea. Possible to do it, but not likely very
wise. Storing the same data twice is seldom a good idea and will usually
result in problems and more problems.