Record access by level and user

[bongolou]

OK, this is what I’m trying to do:

Make a database that will accommodate multiple users with different levels of access.

There will be three levels

3=data entry + restriction to records created by the logged in user

2= data entry (which will be a summary of level3 entries) + restriction to records created by the user who level 2 supervises

1=full access

I have a user info table and seven “GOAL” tables. I want the permissions to be based off the level, but I’m not sure as how to script or calc.

Any help would be MUCH appreciated!

Thanks.

[mr_vodka]

I uploaded a sample file here on one method to do this.

http://fmforums.com/forum/showtopic.php?fid/33/tid/198109

[bongolou]

Thank you sooo much!!!

:yourock: