Hi,
I'm not very familiar with SQL but I'm trying to update fields on multiple tables using a SQL statement in my VBA code. Basically I have 4 tables that all have a yes/no field called Deleted that I want to update to yes based on the PK in Table 1. Table 1's PK is the FK for Table 2, Table 2's PK is the FK for Table 3 and Table 3's PK is the FK for Table 4.
Do I need to write a seperate SQL statement for each table and how do I structure the UPDATE statement seen that Table 3 and Table 4 are not directly related to the FK in Table 1.
Any help is much appreciated
Start Free Trial
