AnsweredAssumed Answered

I need more than one relational path between two tables

Question asked by YuanxuLi on Nov 18, 2014
Latest reply on Nov 18, 2014 by philmodjunk

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.

 

Outcomes