I am trying to limit certain users to be able to edit data in certain applications but not in others and am running into problems. Suppose I have one main application (Personnel) and a related application (Projects). I want users to be able to edit the information in Personnel but not in Projects. Projects is private and not shared with anyone, and yet it seems that by creating a link in the Personnel form to Projects (Personnel can be connected to one or more Projects), it opens up the user to add data not only to Personnel, but Projects as well.
On a side note, I am confused about when to start a new Application and when to create a new Form instead. I had assumed that each application is like a table and that forms are entry points to each table. But further exploration makes me think that perhaps Applications are meant to contain numerous forms (each with its own table behind it). In other words I may be creating new applications when I should be creating new forms. Any advice would be much appreciated.