T
troy
I would like to update a table in my database if a change is made in another
table in my database.
Please let me know if the QBE grid is correct. I dont want to update the
wrong record
Field: Where I wwant the update to go? Such as ProductID
Table: The table that holds the field above? tblProducts
Update to: If I want the data to go to the above table and field I could put
this expression? [dbo_TblProduct].[ProductId] (from above field and table
Criteria: If someone changes a field in any tables I have in my grid. Iwould
use this expression under all tables if chages were made..
<>([dbo_tblProduct].[ProductId])
Can someone tell me if I a on the right track? Thank you very much!
table in my database.
Please let me know if the QBE grid is correct. I dont want to update the
wrong record
Field: Where I wwant the update to go? Such as ProductID
Table: The table that holds the field above? tblProducts
Update to: If I want the data to go to the above table and field I could put
this expression? [dbo_TblProduct].[ProductId] (from above field and table
Criteria: If someone changes a field in any tables I have in my grid. Iwould
use this expression under all tables if chages were made..
<>([dbo_tblProduct].[ProductId])
Can someone tell me if I a on the right track? Thank you very much!