hi

may look long but very simple...
i have a table customer (ID , Name)
users A,B, C

all 3 user retrive data.

A has updated the name filed
after some time B updates the name

now the Point is the App should prompt the user that the record is been updated .. ask to retrive
how will the app know that the record is been updated

and if the user C sit for long time the system should prompt that the data been change from the last retival...

any idea tip tricks any thing
welcome

thanks