Report Link Question

Question

Not sure if there is a way to do this, but I am trying to get a report link to show a child that is is one of multiple related fields. To clarify:

- One project has many daily reports
- A daily report can include up to 3 projects. instead of creating a many to many relationship (which maybe is what I will need to do?) I created 3 relationships from project to daily report.
- On the daily report, you can of course now select up to 3 projects to relate do that single report.

On the projects tab, I could have 3 report links. One for each relationship. Is there a trick to have one report link, and have it show reports where the Record ID is in ANY of the 3 related fields?

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou · Answer

Not tested today, but the option for a non exact match on a report link field always confused me.

Here are my cheat notes.

Report Link non exact matching means that the field on the "Parent" (left) must be contained within the field on the right "Child".

SET NON EXACT MATCH!!!

So you should be able to create a string in the format on the child like

like

List(";", totext([related parent 1]),totext([related parent 2]),totext([related parent 3]))

Let me know if that works. Not sure if you need to have a ToText(field on the Parent for [Record ID#])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community