1 of 1 people found this helpful
What I need to happen is that when a restaurant logs in they will only see the records beloging to that restaurant. Basically this is a search base on the restarant short and I need it to happen whhen they login.
You do this with security / accounts.
Create an "owner" field which is auto-populated with Creation Account Name.
Create an account group, ie, "restaurants", and set the privileges so that they are only allowed to see/edit/delete records which belong to them, ie, Owner = Get(accountName).
That will do exactly what you want.
The final trick is to pretty it up. In the navigation button that takes them to a layout you do a search on the ID field using an asterisk. That will always filter the record set to their records.
I'll check this out in the morning. I am brain dead about this time of night.
I would use FileMaker's Security to create a privilege set that only let them see their own records through a calculation. The privilege calclualtion to see a record would be something like for each table specifying their View to be limited to the following being true:
Get ( AccountName ) = "ABCD" and Company = "Restaurant 1" ; 1 ;
Get ( AccountName ) = "CADF" and Company = "Restaurant 2" ; 1 ;
Get ( AccountName ) = "ESRA" and Company = "Restaurant 3" ; 1 ;