Creating relationship key off a checkbox field

General support questions.
PostPosted: Tue May 23, 2006 6:44 pm

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")....


SeedCode Staff
SeedCode Staff
Posts: 2760
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed May 24, 2006 1:26 pm
(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.
John Sindelar
PostPosted: Wed May 24, 2006 3:27 pm
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.


Return to General Support

Who is online

Users browsing this forum: No registered users and 3 guests

Follow us: