I have a field (repair) that I want to insert an "X" for later use. I want to insert the "X" by clicking on that field. I am having trouble specifying this to work. TIA

Ivan

Do you really want an X or just a mark in a checkbox? You can create a valuelist of 1 and format your field to use that valuelist, then shrink the field down so only the checkbox shows. When you click the field, it will insert a 1, which will appear as an X in the box. When you want to do a find later, you simply enter Find Mode and click the box, then Enter.

In previous versions of FileMaker, you would have had to create a script and assign it to the field, but now in FileMaker 7, do this:

Select the Field and choose Button from the Format menu.

In the list of options, click Set Field.

Specify your field as the target.

Next to Calculated Result, click Specify.

Your calc should read: "X" /*with quotes*/

I agree with Q, as usual. There's no reason to make the field a button unless you're going to do more than just "X" it. He's also right that a value list of 1 is a more standard approach -- don't forget, you can use the same value list on as many fields as you like -- but if "X" is what you actually want, a value list of "X" would also work with a checkbox.

I made a button box and sized it to field. Specified the "X" field where I wanted the "X". The calculation Case (RepairOrders::EstTestInspectOn="X" ; "";RepairOrders::EstTestInspectOn="";"X") works like a champ. Click in field "X" appears, click again "X" goes away.

Life is good. Thanks everybody.

Ivan

It looks like you can simplify this as

Case( IsEmpty(RepairOrders::EstTestInspectOn); "X" )

You can simplify it even more, if you use the valuelist of 1 idea, to IsEmpty(RepairOrders::EstTestInspectOn), and format the field as a checkbox using the valuelist.

I tested the 1 item drop down list. Its not so simple, it does exactly what its supposed to do. A list drops down, 1 item "X", but you have to click on the "X" to insert it. Thats 2 clicks.

I cant get the case function to work now!

I cant get the case(is empty:: to work either!

Bummer!

Ivan

I didn't say to use a drop-down list. I said use a checkbox. You'll only need one click for that.

Maybe if you elaborated on the purpose of your calculation, we could have a better understanding and provide more appropriate responses.