Conditional VL still at war

[Enigma20xx]

Hello,

Here I am once again fighting my particular war with conditional value lists.

I have several car fleets. Composed by cars that can have one or many owners.

Where I'm stuck is when on a day plan, I select the fleet I'm going to work on, and once selected (everything seems ok till now) I want to choose (via conditional value list) any owner of that fleet. I can't accomplish this last step.

As always I try to explain my idea as good as I can in english, but I don't get it all the time (sure comment is going to quarrel, hehe, it's a joke).

I attach a sample file to cover the gaps of my explanation, hehe.

Thanks in advance for the help.

Sample.zip

[Steve Martino]

I need some clarification.

You have a Fleet, comprised of Cars, owned by one or more owners.

So in day plan, you want to pick a fleet, which is comprised of cars, then you want to pick a specific owner for each car in the fleet?

Edit: 

1.  Also, can an owner own many cars?

2.  Do you need to have percentages of ownership?

Edited September 19, 2016 by Steve Martino
additional questions

[Enigma20xx]

Thanks for the answer Steve.

Is not exactly like that.

Owners own cars. With cars y make fleets of cars. So when selecting a fleet, I want to be able to select any owner into that fleet.

I hope that makes sense.

Thanks again.

Enviado desde mi SM-N920CD mediante Tapatalk

[Enigma20xx]

I'm sorry but didn't see the edited questions.

I tried to make my sample as simple as possible and I could have been missing something.

- Fleets are comprised of cars that have the same owners. I group them by the same ownership. (The name of the fleet doesn’t matter)

Lets say:

Bugs and Peter own the Volkswagen 951236 = Fleet x
Bugs and Nikki own the Volkswagen 321987 = Fleet z
John and Nikki own the Shelby 931793 = Fleet w
Nikki owns the Ford 456987 and any other on her own = Fleet y

- I didn’t think of a percentage of ownership, but could be useful.

Thank you.

[Enigma20xx]

Any advice/help?

Thanks.

Enviado desde mi SM-N920CD mediante Tapatalk