Sort Script Dilemma

[steigrafx]

I'm new to Filemaker and I'm trying to assemble a database which includes 5 identical tables. There are six users -- I'll call the "top dog" the superuser.

The superuser needs to open the file and select any of the five tables, then run scripts, some of which include the sort command. The other five users each have a privilege set which allows them access only to their own table. Problem is, when the scripts with sorts are run, the sorts pertain only to the table they were created in and an error message is generated.

Since each table has identical fields, is there a way to tell the sort command to sort on the current table rather than the table it was created in -- sort of like a generic sort on a particular field without regard to the table name?

Or, can I create a separate set of scripts for each table and have them become the "active" script set when each particular table is open?

Thanks,

Kevin

Edited September 30, 2010 by Guest

[comment]

You cannot sort records that are in another table. Have you considered a single table with users having access only to their own records?

[steigrafx]

Thanks for the reply. I didn't realize I could do that. I'm new to this, but I'm learning.

I figured out how to do it by creating a field called record_created_by and populating with the user's account name, then using Record_Created_By = Get(AccountName). But, there's a new problem. The records with no access still appear, only all the fields say . Is there a way to suppress those records from view?

I'm sorry to bother you with what is probably something simple. I just can't figure out how to do it.

Thanks again,

Kevin

Edited September 30, 2010 by Guest