Hello

This is my first post as I'm really stuck this time - although I've found loads of useful advice here in the last year!

I've got a relatively complex DB but am self-taught so I'm sure it doesn't follow 'normal' design procedure!

Basically, I want to restrict access to certain found sets of data based on users privilege set - which I know how to test and have a startup script that gets this data into variables.

My problem is if I do 'find' script steps - it gives the correct data, but still leaves the user the option to 'show all' which I don;t want. If i restrict the interface, it also takes away too much other functionality. They access through IWP and FMnet so same thing with the web interface - it also has 'show all'.

I assume this can be done in relational links, but I'm confused - nothing I've tried works, and it seems like I then have to make a completely new set of layouts per privilege set - just so it points to the right tables?

Am I better off trying to sort out the interfaces, or restricting the data more securely?

Thanks for any help (and understanding!)

Try method I have post earlier:

Post#345409 and Post#338523

You might want to hide the status area from the users and recreate its functionality with customized buttons and calculated fields. For your example, you'd want a button that goes into find mode and adds the Users name to the find request so they only end up seeing records to which they have access.

Welcome to FM Forums.

You don't do this with scripts or with the User Interface. You do it with the Privilege Sets. Search the Forum for Record Level Access.

Steven