If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Updating 2 Different Tables
I have a database that tracks purchases and I want to expand it to also track
account balance. Is it possible to have entries on a form w/subform update 2 tables? Here is more details...I have a form named Purchasefrm based on a table named Purchasetbl and the form has a subform based on a query named Purchasedetailsextendedqry. When data is entered for [PurchaseDate], [PurchaseCategory] and [ExtendedPrice] I would like the table AccountTransactionList to be updated also, fields being: [Category], [EntryDate] and [TransactionAmount]. I hope this makes sense. Thanks. -- Ron |
Thread Tools | |
Display Modes | |
|
|