Hi

I would like to be able to set a database so when a user logs in with his account password he is taken to his required layout, Such as Peter log's in and is taken to layout A and Paul would log in and be taken to layout B. Is this possible in FM7.

Lucky

There would be several ways of doing this via scripts.

Perhaps the simplest would be a script that looks at the accountname and goes to the appropriate layout

if [get(accountName)="Peter"]

    go to layout ["Layout A"]

elseif [get(accountName)="Paul"]

    go to layout ["Layout B"]

elseif [get(accountName)="Mary" or get(accountName)="Sally" ]

    go to layout ["Layout C"]

else

    #general layout

    go to layout ["General"]

end if

Otherways of doing can be using privilege sets -- multiple users can fall under the privilege sets.

if [get(privilegeSet)="Developer"]

    go to layout ["Layout A"]

elseif [get(privilegeSet)="Administrator"]

    go to layout ["Layout B"]

elseif [get(privilegeSet)="Editor" or get(privilegeSet)="User" ]

    go to layout ["Layout C"]

else

    #general layout

    go to layout ["General"]

end if

That's done the trick.

Thanks