This app I use to track clinical trials (can ignore office/doctor sheets) and to provide a link to a facts sheet on our server for review. Pretty simple. Each trial includes one or more sites, but each trial only has one fact sheet
The layout tree starts with selecting the site family, then one would see a list of trials in that section- each with a link to its facts sheet.
Not sure what I did but I broke the relation column I had before. George was kind enough to help me create a solution using a filter function, so it is working fine.
However I am certain I did not solve this issue that way previously. I believe I had used a relations column (or two) along with inline lists only to achieve this same outcome.
Does anyone see another solution? I am mainly doing this to help me understand relation columns again, as at some point I had it working, and of course always better to have two ways to solve a problem.