G
Guest
is there a way to send the information from a form to 2 separate (but with
identical fields) tables?
I have a form where information from the current order is entered. This
form sends information to a table, which in turn sends that information to a
report. Each time the form is opened, the table is deleted, and then created
again to maintain that ONLY the most current record appears on the report.
However, I would like to have a table that stores all past orders as well,
so it does not get deleted each time. Basically I'm trying to figure out a
way to get the form to send its information to 2 separate, but identical
tables. Any suggestions?
identical fields) tables?
I have a form where information from the current order is entered. This
form sends information to a table, which in turn sends that information to a
report. Each time the form is opened, the table is deleted, and then created
again to maintain that ONLY the most current record appears on the report.
However, I would like to have a table that stores all past orders as well,
so it does not get deleted each time. Basically I'm trying to figure out a
way to get the form to send its information to 2 separate, but identical
tables. Any suggestions?