Hi All,
I got 3 tables:
tblSubscription
tblExpenses
tblLineItems
tblExpenses and tblLineItems are parent and child, connected via the ExpenseID (autonumber in expense table and foreign key in lineitem)
tblSubscription holds information some of which is for tblExpense and some for tblLineItem.
How can I make an append query to update both tables? I could do two append queries but not sure how to pass the correct ExpenseID across to the child table?
Any ideas most welcome!
I got 3 tables:
tblSubscription
tblExpenses
tblLineItems
tblExpenses and tblLineItems are parent and child, connected via the ExpenseID (autonumber in expense table and foreign key in lineitem)
tblSubscription holds information some of which is for tblExpense and some for tblLineItem.
How can I make an append query to update both tables? I could do two append queries but not sure how to pass the correct ExpenseID across to the child table?
Any ideas most welcome!