I have an old app written many years ago for single user use. No buffering, no cursors. Just open a table and edit it. I now need to set it up for multi user use. There is one parent table and a half dozen or so child tables some of which are opened more than once with different aliases.

Q1- Do I need to buffer ALL the tables?

Q2- What type of buffering would be best? record level or table level, optimistic or pessimistic?

Q3- Where is the best place to put the tableupdate? lostfocus, form.destroy, on shutdown, etc. I would like to avoid isediting mode and leave it "hot" all the time.

Thanks, please excuse my ignorance.