Yes the Search table will have only 1 large text field and only 1 record. It will be [Record ID#]. It looks like you called that field [ID#1]
To make a field that calculates to 1 the formula is 1. Just a 1 will calculate to 1. 1 is the [Record ID#] of the one and only Search record. call this [Link to Search table (=1)]
On the relationship, the Search table is the Parent. The child table is you table that will be searches with all the records. When you make the relationship, do not use the field that QuickBase offers to you. Use the field you just created [Link to Search table (=1)].
Lookup the Search text field [ID#1] down to the details table. call it [Search text for ID#1]
Make a table report where the filter is
where [Search text for ID#1] contains [ID#1] (assuming that your search target field is [ID#1]
Run the report and let me know that you get the expected hits. The report columns would be the [ID#1] field and any other fields you want, but not that [Search text for ID#1] field.
There should be is OR in the data you enter in the search box. But ideally it would be good to separate the search text elements by a semicolon ;
Post back if you get it working that far and we will continue.
