1 Reply Latest reply on Nov 18, 2014 1:40 PM by philmodjunk

    I need more than one relational path between two tables

    YuanxuLi

      Title

      I need more than one relational path between two tables

      Post

      I have two tables:

      THA Surgery(key: Surgery Number)

      THA Retrieval(key: Retrieval Number)

       

      In THA Retrieval, I have four Surgery Numbers, like Surgery Number 1, Surgery Number 2, Surgery Number 3, and Surgery Number 4, each of which should link to THA Surgery.

       

      What I want to do is:

      Each Surgery Number will associate some fields in THA Retrieval with those in THA Surgery(i.e. lookup values).

       

      The problem is:

      Filemaker Pro 12 says there cannot be more than one relational path between two tables.

       

      I have been struggling for a long time. Thanks for your help.