I must be breaking all the rules!!!

Followers

November 28, 200520 yr

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 November 28, 200520 yr by Guest

November 28, 200520 yr

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.