Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Is your search target a single field, or perhaps just a few fields? I imagine so.
My suggestion is to create a single record in a new table called Search. Add just 1 record ot that table. It will be record ID#1.
Make 1 field as a large text field data entry field.
On the search target table put a formula numeric field with a formula of 1.
make a relationship to the details table and lookup the search target text.
Make a report where the [search target text lookup] contains the search target field in the details table.
Use that report as a report link field report on your search target single record.
So you should be able to just edit the search record, save, and see the hits on the embedded report.
My suggestion is to create a single record in a new table called Search. Add just 1 record ot that table. It will be record ID#1.
Make 1 field as a large text field data entry field.
On the search target table put a formula numeric field with a formula of 1.
make a relationship to the details table and lookup the search target text.
Make a report where the [search target text lookup] contains the search target field in the details table.
Use that report as a report link field report on your search target single record.
So you should be able to just edit the search record, save, and see the hits on the embedded report.