Hello,

Yes, it's me once again. I think this is relatively simple, but for some reason I cannot seem to be able to get it to work. Perhaps I'm on the wrong track.

I would like to know if there is a way in FMP (there probably is...) to perform a find using drop down menus in a seperate layout/table to input the find parameters. Here's an example of what I would like to do.

My database contains a section for trouble tickets. There are a few fields such as:

Ticket number (automaically generated)

Ticket status (open, closed in a drop down menu)

Call back date (calendar)

Call back time (drop down with time vallue list)

To whom the ticket is assigned to (drop down, value list are email addresses of employees so that reminders can be sent via email, there is probably a more elegant way of association a user account with an email address using a seperate table, but for now, I'll keep it as it is)

Now, I would like to have a layout or a section in the "main" layout that would display all of the fields above except the ticket number field plus two date fields and a button (GO!).

To perform the find, I would like to be able to select the status of the ticket (lets say "open") in the drop down field, then two dates (start and end with the calendar so that users cannot screw up), then select the email address of the person and click the GO! button and then, like magic, a list of all the call backs for opened tickets for the user would be displayed.

I'm only starting to be familiar with FMP and I think I may be getting carried away with making some new, cool functions, but is this possible?

You can use global fields for the entry of your search criteria. Then your go button can call a script that goes to a layout of the table that you want to do the search for, enters find mode, sets the fields with your global valuse and performs the find. Dont forget to error trap.

Thanks mr_vodka,

I'll give it a try and update the post.