Kalina Posted January 16, 2008 Share Posted January 16, 2008 I have two tables 1. Production Breakdown Fields: Type, description, act, scene 2. Backgrounds Fields: File name, BGName, scenes I would like a value list for Backgrounds:BGName that will list descriptions from Production Breakdown:description. But ONLY if the value listed in Production Breakdown:Type is BG. Is there any way to do this? Do it make sense? Link to comment Share on other sites More sharing options...
Maarten Witberg Posted January 17, 2008 Share Posted January 17, 2008 Sounds like you need a conditional value list. see here for sample and instructions. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts