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!)
