August 2, 200322 yr this might be a stupid question, but is there a way to have all checkboxes checked on a new record? I want to keep track of my students that have paid for the months. So I have the months in a checkbox valuelist. But if I do a search of the records, it will show me all the students who have paid. But I would rather see the students who haven't paid. Kind of a reverse search result.
August 2, 200322 yr I've no idea why you want all the checkboxes turned on for a new record - it doesn't seem to have any connection with the rest of your question. There's two ways to find the unpaid students: A. Omit Before making FileMaker perform your Find request, turn on the Omit checkbox in FileMaker's side toolbar / status bar. This functions as a 'Not', so clicking on "March" and "Omit" will Find all the students who DON'T have March ticked off. orB. Show Omitted Once you've done your find and have the set of "all students who have paid", then choose 'Show Omitted' from the Records menu. This will swap the current found set of records with the "unfound" set and so you'll have "all the student's who haven't paid.
August 2, 200322 yr Author Oh... well then... that saves me a lot of time. Thanks. I love this forum. I have gotten more questions answered just in a week then I have for two years with fooling around with the program. You guys are the best. I just hope I can answer questions that others have instead of always asking. Thanks guys and gals.
August 8, 200322 yr You can have the check boxes all checked for new records if you want. You just set it up in the autoenter options in the field definition. Copy the valuelist data used for the checkbox from the valuelist definition, and paste it into the autoenter data box in the autoenter options dialog.
Create an account or sign in to comment