2 Replies Latest reply on Jul 29, 2003 6:55 AM by Ian Hunter

    Restricted CMR query

    Ian Hunter Newbie

      In an m-m relationship, I'd like to restrict the
      objects returned on the basis of a field in the
      join table.

      E.G.

      Tables: User, Message, User_Message

      User_Message contains flag 'valid'.

      I want to return all Messages for User which are 'valid'

      Can I modify the CMR to effect this?

      Many Thanks
      Ian Hunter