Hi,

I'd like to make a button on a layout that a) enters the Find Mode, allows you to select a value list item from a pull down menu, and c) automatically returns the found results, without one having to press "Find" on the status bar or having to hit the return/enter key. I saw something about a calculation involving the carriage return operator in a recent post but I couldn't follow it.

Thanks,

Lee

Hi,

What you are describing would be solved easily by an "Field Exit" script involving a loop.

Find Mode

Go to field

Loop

End Loop If (not IsEmpty(your field)

Pause/Resume (00:00:02)

End Loop

Perform Search

Now, if you think you're able to script a Find by solely a Value List, then this could possibly be solved without any script at all, using Filtering Portal technique. The Value List would display a list of keys and you'd make it relate to an indexed field, so that the records matching the value selected can be displayed in a portal.

Lee asked in a Private Message.

Actually, I believe the second option you mention is the one I'm trying to do. I do have a portal on this layout and I was trying to show the set of matching records based on whatever value I selected form the pull down list. So do I need to make a calculation to have the list relate to the indexed field? I'm not sure how to do this.

This begs a further question. What I would ideally like to do is be able to show all my image filenames in the portal. This would be on the left side of the database. The right side would show either the picture field or the description field. You can then use the portal to scroll down the list of filenames and clicking in a specific row will bring up the description or picture related to that particular record on the right. But since I'm only used to using portals to show a subset of records I couldn't figure out if it was even possible to just show all my records in the portal.

As an example is worth a thousand words, download this sample here

It gives a complete answer to your querry by either

- Filtering by category field

- Matching by keyword

- Performing Find by the Return Key

All operations lead you to a portal. Clicking in a row redirect you to the specific record.

Tell us if you're still stuck with it.

May be other would use other methods. That's why I redirected your PM here on board.