In order to allow multiple users to edit the same table, I am trying to split my database into frontend/backend. My question is, if I kept some tables as private, can they act as local copy, and be manipulated by the user at that PC? What I am trying to do is to allow multiple users to have almost like a local copy of a portion of the main table, then only edit the main table after the user is done looking at the data. For that, I wanted each user to have local image of the main table, and was wondering if a private table would act as such.
Or am I approaching this in the wrong way? Please advise.