Hi All-

I have a database of films for my company. We're creating digital assets for each film, and I'm tracking those. I'm also tracking the various platforms these assets will go to. To this end, I have a table for films, a table for assets and a table for platforms (among many other tables for other functions). I have a dynamic value list based on the platform name field that generates a list of all platforms. Users use this list on the asset table to specify which platform a particular version of an asset is for (via a portal). However, some films will not be available on some platforms. I have a checkbox in the films table where users can check off which platforms aren't available for a particular film. I'd like the platforms value list to reflect this by dynamically changing for each film (conceptually the idea being that whatever is checked is removed from the value list). We have too many platforms for it to be efficient to have users check off which films ARE available, since it's usually only one or two platforms that AREN'T available.

Anyone have any idea how I can do this?

Thanks in advance.

See if these help:

http://fmforums.com/forum/showpost.php?post/274656/

http://fmforums.com/forum/showpost.php?post/233897/

First post got me on the right track. Thanks very much!