Hi all, as is usual a situation has arisen that I need to update records on two tables within an access workbook. I could just update both tables by referencing them separately through vba but wonder is it easier to link the common fields within access so that when one table is updated the changes are reflected in second table.
Database is currently functioning so I am hoping not to have to make radical changes at this point.
Basically it is table1 and table2 with 4 common fields named the same
Any pointers appreciated
I created the relationship between the 4 fields in the 2 tables and the relationship lines a re in the right place but I am guessing this is not the way to go as updates to one table are not reflected, how can I address the two records linked by ID2 and update the 4 fields in both with one Query through ADO from VBA
at the moment update finds ID2 on tblDelivered and updates 'Charge' and one of 'Cash' 'Card' or 'Cheque' but I am guessing the two records could be addressed at the same time
Bookmarks