Hello
Trying to take an existing "single file" fp7 application and turn into separation model.
Took file.fp7 and copied to file_data.fp7
Renamed file.fp7 to front_end.fp7
In front_end.fp7 created file reference to file_data.fp7
In front_end.fp7 change the file reference in Relationships from file.fp7 to file _data.fp7.
In front_end.fp7 I deleted all tables except for 1 to hold globules.
In file_data deleted all scripts and layouts other than a basic table view for each table
Things are working great.... except
I do not understand how to work with privileges.
In the single file file.fp7 user Jim is using a privilege set that allows him to only change specific dates, can not add or delete records. This privilege set is still in front_end.fp7, but the tables are not, they are in file_data.
If Jim opens front_end.fp7, does user Jim also "open" file_data.fp7.
File_data.fp7 has the same privilege set as front_end.fp7 but he is able to delete records.
How do I limit user access to file_data when the tables from file_data do not appear in front_end.fp7
thanks
jrt
