Jump to content

Double feature: external record access calc that calls layout // importing a custom menu


This topic is 4397 days old. Please don't post here. Open a new topic instead.

Recommended Posts

The issues with UI/data separation just keep popping up as I go along!

In my integrated file I had privileges set for record access (deletion in particular) that referred to the layout the user was in (layout that is now in the UI file). With separated UI/data, the privileges calling on layout names or layout tables are no longer protecting my records.

For example:

--> I do not want to prevent deletion entirely in that layout, and I do not want to permit it entirely either.

--> I want to permit deletion when child_table::field <>"√"

--> I want to allow deletion of records (including child records that are √) when the parent related record is deleted.

So my "delete" privilege was set to limit calc: NOT(get(layoutname)="layouts of child table" and child_table::field= "√")

I guess the calls to get(layoutname) now refer to the external data file's layouts (which are hidden). If I force the external file to go to a layout by the same name, then it works again... very convoluted and a route I'd rather not employ.

If using layout names is not best practice for record privileges, does anyone know a better way to achieve this type of record access level -- bearing in mind that I don't have fmp advanced so I can't create custom menus? (I would just disable delete and create, and replace all while I'm at it). I am limited to fmp 9 as that is what our office is equipped with.

However - if it comes to that (fmp advanced)-- if I can find someone who has it, could I just create the menu and then return to fmp 9 (not advanced) to pursue the work?

I'd be most grateful for any pointers. Thanks!

Link to comment
Share on other sites

This topic is 4397 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.