conditional value list
I am new to FileMaker Pro 12 and I am setting up a contacts database. I understand that you cannot create a submenu in drop-down list in FileMaker and I am having trouble figuring out conditional value lists. I have looked at a couple of tutorials and still can't figure it out.
What I need to do is create a drop-down menu that will list the category of the individual (Funder, Partner, Vendor, Celebrity, Artist,,Other). And, if you select "Vendor" or "Artist" the next field should make you pick from a list of sub-categories. The sub-categories apply only to these two main categories.
Please tell me the best way of setting up the database to achieve this.