Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 7000 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (edited)

I have a database of 18 courses (i.e. Excel, Word, PowerPoint, etc.)and I have a database of 20 instructors (i.e. Fred, Sam, Bill, Tom, etc.) Some instructors are qualified to teach some of the courses. There is a relationship established between the two databases.

In the instructors database I have a "Data Enty" form that has all the information about an instructor. I have a repeating field that is a value list based on the "course name" in the course database. I click in the field, select the courses the instructor is qualified to teach, so on the layout I have a list of the courses an instructor is qualified to teach in the repeating field. I can search for "Excel" in the field and find I have four instructors qualified.

In another layout "Qualified Instructors", I have a list of the found set. All is going well up to this point.

In the header of this layout, I have the words "Qualified to teach" then I dropped in the field "Course" below this line of type (bet you know where I'm going with this). My result in this field is the first entry of the drop down list of the active record in my found set. I was hoping that that the layout would show "Qualified to teach" with the course name that I had searched for below it in the header and the list of qualified instructors appearing in the body.

Can this be fixed?

Thanks for any help I can get...

Edited by Guest
Posted

Yes, use a global field to contain your search term(s)and then script the find action through a button. Display this field everywhere that you may want to do a search and add a button next to it to trigger the search script.

Make your Startup script clear this field so it is blank on each open. Make navigation buttons clear this field (and possibly show all records) unless you are navigating to the same found set in the same file.

The other way is to use a portal instead of a list. (are there portals in FM6?) Just relate the portal to your global search field and you will get instant results. This assumes that you actually have a relational database and not just a flat file with a value list.

This topic is 7000 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.