Hi,

I need to be able to make a search of the People table from the Meetings table, and make the search results display in the form view of the Meeting table for referencing during data input.

My database has a list of Meetings, a list of People, and the joint table that bridge Meetings with People. There is a portal in Meetings that displays the list of People present in a given meeting. The portal displays:

People ID - On click, a drop-down list of People ID plus the full name of each person is displayed

Full Name - Field entry disabled on Browse mode. Changes according to the People ID selected

However my People table has over 3000 records, so it becomes pretty tedious and clumsy to scroll down the drop-down list to find the specific person I want.

So I'm thinking, if I can somehow do a search of the People table while staying in the Meeting table, and get FM to display every person that matches my search criteria (e.g. all names that contain "Brown") somewhere in the form view of the Meeting table (e.g. portal or as a pop-up dialogue), then I can easily type in the ID number.

This is fairly important because the system will be used by my colleagues who have no experience in FM so it has to be very simple to use. Is there any way to achieve this? Or perhaps an alternative way to achieve the same result?

Your help is greatly appreciate, many thanks

MacGuffin

I think this demo of a popup select list will be helpful.

Sorry for the delayed reply. The pop up select list works extremely well and I've modified it for other purposes.

A million thanks for the help and great idea!

MacGuffin