Greetings,

Maybe someone can help - I have 2 tables 1. Quotes which has a unique field QuoteID and a global field gQuoteLocation and 2. Quote_Detail which has QuoteID, QuoteDetailID and QuoteLocation.

I've set up a layout with a portal so I can see the one to many relationship between Quotes and Quote_Detail. When I have the relationship set only for Quotes::QuoteID = Quote_Detail::QuoteID everything is fine. And then I have to go and get fancy.

I added a relationship so that Quotes::gQuoteLocation = Quote_Detail::QuoteLocation. Everything works as expected, that is, I can filter by location, as long as there's something in the Quotes::gQuoteLocation field.

My question then is -- how can I keep this relationship/layout and see all locations? I've tried putting * in the gQuoteLocation field, I've tried a return, I've tried keeping it blank.

What, pray tell, am I missing? Or do I need a separate relationship/layout to see all?

Thanks

Typically you'd make a calculated field in the related file:

"All" & ¶ & Quote_Detail::QuoteLocation

Then you could add "All" to your value list for Quotes::gQuoteLocation.

Make sense?

Thank you very much. I was trying all sorts of variations on your suggestion and finally got it to work.

Apparently it has to be a Text field with an auto-calculation to work as opposed to a calculation field.

Again, very much appreciated.

MJ

Glad you got it to work. FYI a calculated field should work, unless the Quote_Detail::QuoteLocation field cannot be indexed for some reason. But if that were true then it shouldn't have been working as you had it.

I don't know why I was having so much trouble but I'm relishing the fact that it's working now.

Thank you again for the tip.