Can filemaker be used as a backend for an employee intranet
I'd like to make items in our FileMaker Database available to employees. We'd like to publish it on an intranet, using either IWP or PHP. We's like employees to be able to log in but only see files that are pertinent to them. So for example, we want them to be able to see and change their address and contact info, but not another employees. And we want them to see projects they are assigned to but not other employees. So for example we'd like a sales rep to be able to view their closed deals and details. Or a service rep to be able to see their scheduled jobs and details.
What is the best way to set up the database and login so that users are restricted to being able to view only their data? I know we can setup user access, but that limits users to view certain layouts, what's the best way to limit them viewing only data that truly pertains to them.