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

I have found little to futz with in my UI priv sets since there is only one record and only interface related data. I have two data files, and do all my priv. restrictions in this back-end files. I just make sure all the sets and passwords match up between the files.

Also if anyone tries to access the data file directly, they just get a locked screen with a message.