Hi, everyone,

I'm trying to make up a database of my record collection. I hav the fields YEAR, LABEL, TITLE and ARTIST. I can get my conditional value list to work so that when I click on LABEL it brings up the lables for the YEAR that I selected. My question is, how can I get the TITLE to show only the titles for the label and year previously selected and then have the ARTIST field display only the artists for that TITLE, LABEL and YEAR? I would really appreciate any help with this.

It gets a little more complicated when you have three levels of conditional menus and the third level may have overlapping categories. Try this example file.

http://www.filemakerpros.com/MULCONDDUPS.zip

Thanks, that works great for the first three fields. Now, is there a way that I can get the ARTIST field to display the content based on the other three fields? Thanks

Once you understand how the technique works for the first three fields, you should be able to expand the technique.

Thanks JOhn,

I got it figured out thanks to your help. So, it seems that by doing it this way you can have as many levels as you need. Of course you'd have a ton of relationships, but it should work. Thanks again for taking the time to help us inexperienced users who would otherwise be balder than we already are.