Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
Ah, it is a common misunderstanding that you need a Relationship to create a Report Link field. One has nothing to do with the other. But when you build a relationship QuickBase in its infinite munificence, creates a report link field on the left side of the relationship for you as a convenience.
A report link field only gets configured with two fields. What is the field on the current record i am matching on and what is the target app, and target field to match records in another table? So, while you can make a relationship based on a 1 = 1, you don't need to. The focus record ID is record ID# 1 as there is and only ever be one record. so on the Items table make a formula field with the formula of 1. Then set up a Report link field using it. The report initially show all items, but then make a report to use on the form of just illuminated items.
A report link field only gets configured with two fields. What is the field on the current record i am matching on and what is the target app, and target field to match records in another table? So, while you can make a relationship based on a 1 = 1, you don't need to. The focus record ID is record ID# 1 as there is and only ever be one record. so on the Items table make a formula field with the formula of 1. Then set up a Report link field using it. The report initially show all items, but then make a report to use on the form of just illuminated items.