By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,393 Members | 1,586 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,393 IT Pros & Developers. It's quick & easy.

save a record in two different tables

P: 2
How do I save a record (on a form) into two different tables at the same time?
Not an expert,but more than a beginner
Oct 6 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

You need An append Query... Create it from the Query Designer

In the macros use OpenQuery macro and assign your Append query

Then in your form in the respective event that fit you assign this macro!

:)
Oct 8 '06 #2

P: 2
Hi,

You need An append Query... Create it from the Query Designer

In the macros use OpenQuery macro and assign your Append query

Then in your form in the respective event that fit you assign this macro!

:)
Hi PEB,
Thanks for your reply.
I've had a go at Append,but I don't want the "messages" displayed.I want to click on the "Close Form" button & have the Save procedure run in the background.
info: I'm entering new data via the form.When finished entering data,I click on button "close Form" & data is saved to main Table.I used basic method(macro builder) ie Close formInspect,& Save.Here is the problem.The main table contains data about machinery,some machinery needs repaired.Faulty machinery is tagged "FAULTY" & after I repair faulty the record is Updated & tagged "NOT FAULTY".I now don't have a Historic record of equipment which was faulty.That's why I need two tables.One table(Main Table) which has updateable fields & another table(Historic) to keep a record of all that was faulty.
Ideally,I would like to click on "Close Form" & the data would be saved to the Main Table,& at the same time,filter the records tagged "FAULTY" & save these to the Historic Table.Does that make sense to you?
Oct 12 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.