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

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

    BenjaminA

      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