I need more than one relational path between two tables
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.