multi teir popup menu?

[Our Town]

Hi, I have a large list of supplies. I am trying to create a simplified menu that branches out by catagory type, then specific items . I have seen this somewhere. I know on websites... Can this be done in FMP?? Thanks for any help you can offer.

[BrentHedden]

Sure - it's not really a popup menu, but actually what's commonly known as a 'Hierarchical Portal'. It's very cool, and can get somewhat complicated to setup. There are several different examples available, the one I like the best is from a company called Excelisys. Check out this site for a well-written white paper and demo - http://www.excelisys.com/services/fmp7/tips_tricks.htm They also have other whitepapers on other topics that are well worth reading.

[sukisue]

That is a super cool example... But I'm looking to do something a little more simple...

1st field is a list of continents (I pick North America)

2nd field is for countries & shows a list based on selection from 1st field (Canada, US, Mexico)

I was able to do this in FM6 by doing a self-relationship (or whatever its called) but can't figure out how to do it in FM7.

Any suggestions?

[BrentHedden]

Ahh - Sukisue I believe you care referring to what's commonly called a conditional value list.

I found a few different posts here based on this, so I won't repeat what's already been said. Check out this post -

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=149513

[Fenton]

There was a new fairly simple techinique for this, in an example file by S

Popglobal.zip