How do I create a drop down field to select a record set ?

[keelbolt]

I have a layout that shows single record sets from a table, including the name of the record set. I need to create a drop down list on the layout with the names of the individual records so that I can select a recordby its name and get the layout to display that record. It should be simple, but I can't do it. Can anyone please help?

Edited September 16, 2010 by Guest
To subscribe to replies

[bcooney]

I don't understand what you mean by "record set" or "record name."

I can guess and translate...I have a list view layout that shows all the records in a given table. I'd like to click on a record in the list view and navigate to its form view.

Is that what you're asking? If so, it's a simple button in the body part of the list view with Go to Layout (and select your table's form view layout).

[keelbolt]

Thanks for your reply.

No, not quite.

I have a layout in Form View for a table called 'Visits'. That layout shows related fields for a particular visit.

I need to create a drop down list on that layout that shows all the visits and allows the user to select a visit so as to show the records relating to that visit.

I thought I could use a Value List with the Visit ID and the Visit Name, set to show only the Visit Name, but this won't work because it won't change the record.

At the moment, I'm having to switch to Table view to select a different visit. There has to be a way to do this.

Sorry, descriptions are awful. I'd show you if I could...

KB

[bcooney]

This is probably what you're looking for:

http://www.fmforums.com/forum/showpost.php?post/289092/

[keelbolt]

Yes, except that the portal on the left needs to be a drop down list rather than a portal.

[bcooney]

Create a popup list using a value list of (ID name). Then attach a script trigger to the popup OnObjectModify. The trigger does a gtrr self-join in current layout.

EDIT: The popup is attached to gID.

Edited September 16, 2010 by Guest

[comment]

Or:

NavPopup.zip

[bcooney]

You'd need to watch out for record lock on that one, comment. I've used such a technique, but base the layout on a SYS table.

Overall, popup nav will hit a wall as soon as the popup becomes too long. I'd only go this route if I know the popup will stay manageable.

[comment]

You'd need to watch out for record lock on that one, comment.

You are right - and the same applies to the demo you have linked to earlier. But it would work well for displaying only.

[Dchall_San_Antonio]

How do you do that? I can download it and use it but can't see how it's done.