Limiting user access to records

[JariV]

Hi,

I have created a runtime solution (approx. 30 related files)with FPP Dev6, originally to be used by a single user at a time.

Now I'm trying to create a modified version for multiple simultaneous users as well(10-20 multiple locations)- the best way to this seems to host the database on a FMP server, right?

The challenge is, that the client wants to restrict the access to database records based on the user, ie. all users can access all the files, but can only see the "permitted" records. Is this somehow possible with FMP Server7?

Thanks in advance,

Jari V