AnsweredAssumed Answered

"cascade" table dependencies : how to do this query ?

Question asked by BenjaminA on May 11, 2013
Latest reply on May 12, 2013 by philmodjunk

Title

"cascade" table dependencies : how to do this query ?

Post

     Hello guys,

     I've been trying a long time but can't figure this out, hopefully someone will have a tip... I'm obivously not an FM ninja sad

     Basically my datamodel is the one attached.

     My question is : how do I get a list of COUNTRIES for which NO CITY is involved in any travel (meaning : no city of the country(ies) returned is/are ever listed as a departure or destination in the travel table).

     I suspect FM doesn't like my dependency between the city and travel tables thus I never get the results I want.

     Thanks a lot !

     Cheers,

Capture_d%E2%80%99e%CC%81cran_2013-05-11_a%CC%80_18.40.47.png

Outcomes