Example:

I have a checkbox field called "ToolApprovedUsers" showing all employees within a "Tools" table. For each type of tool, the administrator can select which employees can see, and therefore use the tool, by checking their names in this checkbox.

The login for the employee is a global field "UserLoginName", which is the key for many relationships dictating what they see within their interface, one item of which is the "Employee Tools" portal.

I want to create a relationship that will allow the Employee Tools portal to show the tool, if the UserLoginName is one of the "checked" names in the ToolApprovedUsers field.

How can I do this considering that field has many different employee names? (there's obviously no relationship symbol that denotes "includes the value")....

?

Nate

(This is one of my favorite things about FileMaker.) Just make the relationship to "ToolApprovedUsers" using the equals operator. FileMaker treats each return separated value as a separate match candidate for the relationship.

Gee wiz, you're kidding me!

I wondered if it would work but though, "naw, equals means equals, Nate!"

Guess I should have tried it.

Thanks as always, John.

Nate