relating drop down menus question

[Justin Brandt]

hello out there is FMP land!

I have a question about relating tables etc... I'm trying to build a database with related drop down menus. Say I have a series of drop down menus, the first has software makers listed (Adobe, Microsoft, etc...), then I pick, say Adobe. I want the next drop down menu to reflect only the products that Adobe makes (or each other software maker). The user guide doesn't go into very good detail on how to do this, it talks about relating tables (even has a tutorial), but I can't figure out how to do this drop don menu thing.

Thanks in advance,

Justin

[QuinTech]

Hi, Justin, and welcome to FM Forums!

For some reason, this subject has become hotter than Jessica Simpson this week. (Or is that bigger than Jesus?) See this link and this link for tips on how to do this.

HTH,

Jerry

[Justin Brandt]

Jerry,

your example file helped tremendously. I still have a problem, though.

OK, so I have to software companies, Adobe, and Envi. Adobe makes three products, and Envi two. When I pick either company from the list, all 5 products from both companies show up on the next list.

Any idea what I might be doing wrong?

Thanks again for your help!

Justin

[Justin Brandt]

oh yeah, I almost forgot, if you want to take a look at the mess that is my FM file, here is it. I don't get it, I was able to get teh 'vendors' relationship to work within 2 minutes...

anyway, thanks again for any help you gave give me...

fmpro_justin.zip.zip

[-Queue-]

You want to put your products in a different table so that you can relate the selected company name to a company name in Products and have the value list pull only the products where the company names match.

[QuinTech]

If you look at the definition for the value list "Products," you will see that you have selected the option "Include all values." Change this to "Include Only Related Values Starting From Asset Management."

Also, i think you want the relationship from Asset Management to Asset Management 2 to be from CompanySelection to CompanyName. Currently, CompanySelection relates to CompanyProduct.

J

[Justin Brandt]

Jerry

Oh my god!!

THANK YOU!!!

you're THE MAN!

thanks again,

Justin

[QuinTech]

Thanks, Justin. It looks like all my years of trying to stick it to the Man will be coming back to haunt me, then.