How to I add a Search field ?

October 9, 200916 yr

Hi, I am very new to FM, so please be gentle on me if I post in the wrong category.

I just bought FM 10 advanced for windows.

Developed a database for Miniature figurines, now I like to add a - search field -, like a drop-down list with a - go - button next to it.

The user either select pre defined words or can edit his own word. Then he clicks on the go button and the results are shown. If there is a script somewhere I would be very happy.

October 9, 200916 yr

Hello, Matt, welcome to the Forums. You've posted in the correct subforum, so congrats are in order! We try to cater to new users here, so don't be shy.

Your post made me think of many approaches, actually, because with FM you can solve a problem in many ways. But, before I describe fancy ways to create a Search screen, it is best for you to understand some fundamentals.

In FM, there are modes. Browse is the mode where you create and edit records. Find is the mode in which you specify search criteria. FM will "Find" all the records that match the search criteria. For example, if you enter "Unicorn" in the Figurine Type field when in Find mode, and Perform the find, FM will isolate in a "found set" all the records that have "Unicorn" in the Figuring Type field in that table.

Do you understand how to use Find mode yet?

The next thought I had was your request for a drop-down list. This is called a "value list" in FM. If you wanted users to see what already is in the Figurine Type field, you could create a value list of types and assign it to the Figurine Type field.

October 9, 200916 yr

Author

Hi, thanks for the reply. Yes I do understand the - modes -, but what I want to do is: compile and .exe solution that when open, the tool bar is hidden. I think the value list is somewhat attractive to me, and perhaps to the client.

I am open to any help.