I forgot to add that the database is password protected using the security component in the widget builder and the filter (the password is best) is activated when the user logs into the database.

Igor,

I was just typing a more detailed explanation and realized that it wouldn’t work, because the MTH system doesn’t support multiple User ID’s and Passwords for a single database.

The work I do is best supported by embedding everything in my websites rather than bringing clients into MTH.

Creating filtered views and being able to generate a link or embed code is a good solution.

But, a more flexible, powerful solution is to filter on the fly using the password protection functionality in the widget — User ID and Password — with User ID as the filter. When a user logs into the database, only records associated with that User are shown.

For instance —

I create a Training Form that includes the field: Your Supervisor’s Email among the many other fields.

I make the database password protected (this would only work if I could assign multiple User ID’s and Passwords) assigning four different supervisors unique User ID’s (their email) and Passwords to access the Training Form database.

When a Supervisor logs in to the embedded database, only those records that include that supervisor’s email (which is the User ID for the login) are included in the records shown.

In this way, I am able to provide a single access to filtered database results.