Selective view of files for clients in pro 14
Is it possible to allow a client limited access to our database
Min requirement they log in with own log in details and all they can see is their own cases we have on file
Max requirement they can log in with own log in details they can do as above but if the want to add a record they can i.e a new case for us to handle and if so can an alert be sent advising that a new case has been added.
It all sounds possible. You can limit a user's access to specific records using a "lock expression" specified in their privilege set.
See "Editing record access privileges" in FileMaker Help and check out this particular sub section: "Entering a formula for limiting access on a record-by-record basis" for a description of how to set this up.