We are using FMP version 9 and want to do the following
- Post a simple web form from FMP 9 for our users to enter data.
- Allow the user to log in through our current employee portal, click a link and access the FMP form.
- Restrict the user's access to records in the FMP database to only their location.
- FMP must use the portal login credentials to authenticate them against Active Directory (the SSO part).
Sounds simple enough but I haven't used FMP for several years (got into the management end of things). Publishing the form for web consumption is no problem. It's the SSO part that I certainly need help with. It would also be OK for the user to come in as a guest (without having to log in again) as long as the data they see is only for their location.
There are about 300 locations that would have access to the form so it's vitally important that the data be segmented for each location. I would prefer to create 1 database for all 300 locations rather than creating 300 versions of the same database.
If you can point out any posts that speak to these issues I would appreciate it.