Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Limit Quick Find Search to only active, enrolled students


Recommended Posts

Hey all,

Is there a way to limit the quick find feature to search only in the set of current records? In our database here at a school, we have about 1200 records, only 367 of which are active, current students. But when teachers search for Luis Perez for example, 2 students come up - an active one and a non-active? Each active student has a field marked "KSPA" if they're currently enrolled. The field is blank or some other designation if they are not longer at the school.


So can the quickfind only find from students who are enrolled currently? I could put the unenrolled students in a archive table, which might be the best suggestion. Any other thoughts?


Link to comment
Share on other sites

Probably the best way to go is to make your own scripted search using dedicated global entry fields - taking current enrollment status into account - that is easier to use (and faster) than searching all the records. But having said that, I don't know how much faster searching 367 records will be than 1,200. Both will be quick.


But... I thought "quick find" was introduced in FileMaker 11?

Link to comment
Share on other sites

That makes sense. I'll make my own scripted search. That's the best thing to do really. I'm seeing that the quick find searches all the records. I'd rather limit the search to only the currently enrolled students, so teachers do not accidentally find a kid that's no longer enrolled.


Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use