[Solved] Store data simultaniously in 2 tables

[dreamquartz]

Hi All,

I would like to be able to store information in 2 different tables at the same time.
I also would like to be able to reset/overwrite the information in 1 table, but add the information in the 2nd table when new information is entered.

Can someone provide me with some guidance, please

Dream

[keme]

Dual (concurrent) registration of same data is usually a bad idea.

If the purpose is to enable some kind of "rollback", transaction handling may be for you.

If you need a "recent history", add a timestamp field and create a "recent" query filtering on the timestamp.

You could also use an update/reset query, transferring data from the 1st (data entry) table to the 2nd., clearing the 1st table as you transfer data. To show all entries, you can use a query like TABLE1 UNION (ALL) TABLE2.

[eremmel]

It will help when you specify your question at "requirement" level and not at technical implementation level. For many "Requirements" there exists default solution patterns. Keme is guessing in his response what your requirements are.

P.S.
A technical answer can be "Use Triggers" your favorite enemy.

[dreamquartz]

It will help when you specify your question at "requirement" level and not at technical implementation level. For many "Requirements" there exists default solution patterns. Keme is guessing in his response what your requirements are.

P.S.
A technical answer can be "Use Triggers" your favorite enemy.

It's related

It was a thought and could not find anything about it.

Dream