Conditional Value list with a twist
Basic setup is: projects table and a people table. Projects have a value for specifying which group/team is working it. Based on that value, a conditional value list only show's people from that group/team. The tricky part, is that there is a special team whose members should always be available in addition to those on the regular teams. I thought I could edit the instance of the relationship that's used for selecting the teams, but you can't have condition 1 OR condition 2 in a realstionship! Any thoughts? I'm keeping the basic table structure as simple as possible, once I get this technique down it will be echoed in other parts of the database. Any ideas?