I have a parent - child form, for products, that is made from two views. The parent view (product) is buffered as Opt Rec and the child view (components) is buffered as Opt Table.
If a user modifies any part of a product I need to determine if the product has been changed in any way by another user. This would include changing any field in the product view record, changing any field in any of the component view records, an added component record, or a deleted component record. If any of these things have occurred I don't want to save the current users changes.
I'm pretty sure I can detect any modifications using CURVAL() and OLDVAL() on all fields but I'm definitely stumped on detecting an addition or deletion. Any ideas greatly appreciated.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.