Simple Update Query

[Guest]

I have 4 tables in my query. If any field or fields from one or more of those
tables change or gets updated. I would like it to update the master table
when the query is ran. Would I just put the following under each field? and
put a "Is Not Null" on the master table product ID? The Master able alreaady
hold the records but if any field gets changed I want it to update the master
table.

<>[dbo_tblProduct].[StateAbbr]

 

[Joseph Meehan]

I have 4 tables in my query. If any field or fields from one or more
of those tables change or gets updated. I would like it to update the
master table when the query is ran. Would I just put the following
under each field? and put a "Is Not Null" on the master table product
ID? The Master able alreaady hold the records but if any field gets
changed I want it to update the master table.

<>[dbo_tblProduct].[StateAbbr]

4 tables - Master Table . ??????

" if any field gets changed I want it to update the master table. "

Normally any filed you change in a query will change the data stored in
the table related to that data.