In FM you could use a calculation to define record level access. ex:
RepID = 123 (Per Table)
This way it was easy to implement security without a lot of coding using the same forms. Administering FM solutions with multiple tables was a nightmare due to their data model, but that was one nice feature when having 100's of users.
With servoy I was hoping to implement record level security as well, using the same forms, allowing indivduals only access to their records.
I am sure this is possible using methods, but I was really hoping to avoid multiple methods passing variables from form to form. Can someone provide me with some direction as to the easiest way to accomplish this.
I will have local users / terminal server clients and wide area users.