Report Link 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 re...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNot 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
------------------------------
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
------------------------------
Worked!
Also, turns out you DO NOT need to to text the record ID on the parent. Worked fine matching the record ID on the parent, with a non exact match to the Related Parent String.
------------------------------
Mike Tamoush
------------------------------
Also, turns out you DO NOT need to to text the record ID on the parent. Worked fine matching the record ID on the parent, with a non exact match to the Related Parent String.
------------------------------
Mike Tamoush
------------------------------
- Hi Mark
I'm trying to do the same concept but I cant get this to work. This is the second post I have found on this exact topic but I don't get the same positive result.
I have a list of Asset ID nos in table C. I want to have a report link in table C that uses this list of Asset ID nos to filter a report in Table A (Asset table) so that I can see this report link as an embedded table in the forms in Table C.
If I have only one Asset ID no in the list in table C then linking the report link is easy. But I cant get the report link to work using the list.
I have created a dummy field in table C to test your solution above
List(";", ToText(31284),ToText(32763))
I then used this field to link to a report link in Table A
------------------------------
Eugene van Rheede van Oudtshoorn
------------------------------- MarkShnier__YouDoes your set up meet this behaviour
Report Link non exact matching means that the field on the "Parent" (left) must be contained within the field on the right "Child".
Your example (which may be your need) looks opposite to this solution and hence will not work.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Well no. The left is a list of ID nos and the right is a table were each row is only one ID no. So currently the search is is saying the right side needs to contain "31284;32763" and this wont be true because the right side will have one row that is 31284 and another row that is 32763. One row wont contain 31284;32763. i was hoping that I can get Qb to recognize that this is a list and then basically change the search to read contain "31284" or "32763"
------------------------------
Eugene van Rheede van Oudtshoorn
------------------------------
