Valuelist based on two relationships

[Aussie John]

I have photographs which show based on a relationship of two keywords (by using a relationship back to two global fields). The valuelist of first field is based on values on the keyword of the daughter table (building name). The value list for the second global field (the building storey) is created with a self joining relationship of the first keywords. Unfortunately the valuelist only works once the relationship has been resolved and have manually typed the correct second keyword.

Hope that makes sense.

Is there any way around this?

Thanks

[Fenton]

I like this method, by Søren Dyhr. I'm attaching his file (again). It uses a simple but clever logic. Which is that the Value List Items is the index, all items. If you use that when the choice field is empty, you're basically saying "ignore this field for now" and the relationship still works (which it doesn't, as you've seen, when you try and use an empty field in a relationship).

http://www.fmforums.com/forum/showtopic.php?tid/144255/post/144255/hl/+Dyhr/

[Aussie John]

thanks that is answer. I was looking to filter the valuelist but that is possible if i select the show only related items in the valuelist definitions.

Excellent.