Check Box Lookup

[AudioFreak]

I'm not sure, but this has to be possible.

I would like to have a field that is a Check Box show looked up values specific to the type of unit. Basically user puts in say "Ford" then Option field populates with available colors for "Ford".

I have an options table to store the options. The lookup works fine if the field is a regular field. But I'm not seeing the way to allow it to be a checkbox field due to having to make a value list. I don't want to show all the options for other units, only ones that pertain to the specific type.

Little Help?

Thanks, Michael

Edited June 13, 2007 by Guest

[jteich]

See http://www.virtualvermont.com/FMP/ Dynamic Valuelist.

-jens

[AudioFreak]

Thanks for the link but I ended up finding what I was looking for. Define ValueList as Show Only Related values. Never noticed that checkbox before while defining a valuelist.