How about some specifics?
When i do this...
I get this....
And i expect this....
Would you just walk into an auto repair shop.. yell " My Car is broke!" and walk out?
I like your answer. But I accidentally hit the enter button, fat hands
I updated my inquiry
Just for debugging purposes, put a copy of this field on your layout next to the original, but modified back to edit box format so that you can see the real data. Check box and radio button formatting can hide the real data stored in the field being search in a find--especially since editing the value list does not change the data actually stored in the field.
Changing the field to edit box work. So how do I use a Check box and radio button field.
That never happens to me ....
The checkbox displays X only.. if the list source is defined as having values "Y" and "N" then find on "Y" or "N" not "X". For testing purposes (as PMJ suggested) put the checkbox AND the edit box on the layout so you can see what is going on with the checkbox control AND the data
If entering find mode, clicking the check box, then performing the find does not find the records that you expect, it is because the value list is not entering a value that is present in that field for the records not being found. Thus, for debugging purposes, you can check that edit box field to see why those records where not found.
For example, you can attempt to find records, then do a "show omitted records only" option from the records menu and inspect the data in this field to see why those records were not found. You can also see what data is actually being entered into the field when you click that check box.
As stated earlier I replaced the Y & N with X in the the Value List , Still not finding the information. I'm not sure what you to with the "edit box on the layout so you can see what is going on with the checkbox control AND the data". I've added an edit box field. When I place an "X" in the field, perform Find, That information is found and an "X" is in the Checkbox field.
What I have discovered; I removed all values from the Value List and replaced with "*" (Zero or More Characters)
When I perform Find the "X" is now found. A work around but I don't understand if the Value List only contains "X" why then When I click in the field and an "X" is entered why dose the Find does not work.
Play with this in find mode.
If you enter Y in text_box or select the Y in check box and perform find it will show two records.
If you enter 1 in text box or select the 1 in check box it will show two records
if you enter N in text_box or select the N in check box it will show three records.
If you select Y and N in checkbox it will show zero records.
If you enter = in text_box you will see three records.
If you enter * in text_box you will see seven records.
What i was trying to illustrate is the checkbox concept that the X in the checkbox may not be the actual value in the data.
everything depends on the value list settings.
Exposing the data field AND the checkbox control at the same time allows you to see this phenomenon.
This is what PMJ was suggesting as well.
check boxes.fmp12.zip 64.5 K
That is not what I meant.
Take your existing field. Make copy of it. Change the field format back to edit box for this COPY of your existing field. This gives you an unformatted view of the actual data stored in your field.
I'm with you now. When I change the existing field to edit box there is no entry. I even check that the text was not set to White text.
Still not what I meant. I said to make a copy of the field. This is so you can compare the original to the copy. This helps you understand how check boxes work in Filemaker.
And you can then perform your find and check the edit box copy of the found and omitted sets of records to see why some where found and others not.
So to repeat again, make a copy of the field. You can select it and press ctrl-D in windows or command - D on Mac to get a copy while in layout mode. Then use the inspector to change the copy's format back to an edit box.
Now enter find mode and click the check box. Note what value appears in the edit box copy. This is the value that will be used as search criteria. Perform the find and then check these same two fields to see what data is in the found records. Select Show Omitted Only from the Records menu and check to see what data is in this field for the records that you did not find.