multiple field data from checkbox

[sirtemplar]

i would like to ask if the ff. is possible in filemaker and how to implement it.

i have a database with a field called "degrees" to show degrees earned by the person. it's possible that a person have more than 1 degree.

i want that to fill this field, the user will be presented with a window with a list of all possible degrees i define, in some sort of checkbox set, check the degrees applicable and in the end fill the "degrees" field with values separated by commas.

thank you

[jamesducker]

Your "list of all possible degrees i define" needs to be a value list. File -> Manage -> Value Lists.

Then go to layout mode. Copy your degrees field and paste it elsewhere on the layout, so you have it on there twice. Make both of them nice and big (several lines).

On one of them only, right-click on your the field and do field format... set it to be a checkbox set, with values from the new value list created above.

Go back to browse mode and experiment with ticking/unticking the boxes. You will see in the other (non-checkbox) version of the field that it is still a normal text field... the different degrees come and go as the other field is ticked.

If you want them comma-separated, instead of on multiple lines, then don't change the field you already have. Make a separate calculation field whose formula is:

substitute(degrees,"¶",", ")

Hope that helps.

James

[sirtemplar]

thank you. since there are more than a hundred degrees to choose from, is there a way to have the check box scrolling than on several lines?

[CCBtx]

How do I "watch" this post for the replies?

[Lee Smith]

Click on the [color:red]Subscribe to Topic Button below