You'll want to set up a table occurrence for each value list. Depending on your naming convention, they could be something like this:
I would suggest creating a field called c1 (constant 1) in the source table, with a [stored] calculated field set to = 1. Then base each relationship linking c1 to Type 1 FLAG, plus whatever other criteria you need. Have your value list with fields from the appropriate TO and show only related values, starting from Business.
Thanks a lot for your help. I was nearly there but I my calculated field was not set up as "stored".
Adding this does the trick!
No problem. I should have also said that the c1 field can't be a global field. You would think it would work, but it doesn't. There are other threads here about that.