16 May 07 15:15
In your post you wrote in part:
>>one person wants a list with all the info from the database another person just wants name <<
To make it simple now, you make for each person a layout, with the fields they want, in the order they want, even in the color they want, and give that layout a appropriate name (f.i. JohnDoenamesList - what stands for the layout with the names like John Doe wants to see it).
The problem now will be to direct each different user to his/her layout.
To do that, FileMaker needs to know who's at the steering wheel. WOW, who is the user at the moment that given user clicks on a button to go to a layout, his/her layout.
One way to do that is on the access level, where you putin all the names of the possible different users.
Go to File -> Access Privileges -> Groups: fill in "John", click Access.
Give privileges to layouts.
Now you can link your navigation script to a group or a single user by referencing the group oruser in the script, like I mentioned above.
Or you can put a global field (nameUser)on an entry layout, where the user has to enter his/her name prior to use the application.
The script needs to make a reference to that field first.
To accomplish that you make an Entry layout with just one field, the global field.
The openingscript can be something along these lines:
Go to layout (openingsLayout)
Set field (globalField; "") /*this will make the global empty*/
Go to field (global) /* this will put the cursor inthe global field*/
The user fills in the name.
Redirect theuser whereyou want by script, checking the name first:
nameUser = "John";Goto layout (the layout for John)
nameUser = "Flor"; Goto ayout (the layout for Flor)