I have events table where the values look like below

Event_ID EventName

1 Event1 2003

2 Event2 2003

.

.

.

10 event10 2003

11 Event11 2004

.

.

22 event22 2005

.

.

30 event30 2006

I have a field from different table on the layout which accepts the data from the Events table eventName field where I need to pick from one of these events. But there are thousands of events, so I want to group them by year.

When I click on the event name, it should dispaly a pop up menu by year when I hover over the year, it should display all the events from that year and I select one of the event from the list and the value os that should be set to the event field.

Like how we have menu and sub menu in windows.

Is this possible ? Please advise.

Thanks

Have a look at this demo. It uses a conditional value list to display only events in the selected Year.

CondVL.zip

Thanks for the reply bcooney,

But what I was looking for was something like windows startup menu. When you click on Allprograms you get list of programs, when you hover the mouse over the ones with arrows, that lists more pragrams.

Something similar to that, When you click on a feild a popupmenu with all the years show up. when you bring the cursor over any year, it shows all the events in that year and you select one of them which gets filled/populated into the field.

I am not sure if we can implement like this or something similar to this in FM.

your comments and ideas help.

Thanks

Do not believe that you can do that in FM natively.

It seems that ALL the conditional value lists work outside of portals. Using your example, can you base the layout on YEAR and put a portal based on EVENT on that layout. Then use a popup so the user can select just the events related to the displayed year?

I have a specific problem related to this situation and can't get it to work:

http://ronaldogordono.googlepages.com/valuelist2