4 Replies Latest reply on May 12, 2013 7:37 AM by philmodjunk

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



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


           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 !