Forum Discussion
ArchiveUser
8 years agoQrew Captain
Trying to set this up. First problem for me might be not understanding data entry.
- Make 1 field as a large text field data entry field.
So the Search table will have 1 field only, and it will be Text?
- On the search target table put a formula numeric field with a formula of 1.
I can make the formula field, but how do I make the value = 1?
- Make a relationship to the details table and lookup the search target text.
So the table I wish to search is the Parent and the newly created Search table is the Child? What should the reference field be? I can enter the Lookup field as the one field I created in the Search table.
- Make a report where the [search target text lookup] contains the search target field in the details table.
I don't understand this. Does this mean I should make a Table Report with the Lookup Search field and the field I wish to search in as columns?
Use that report as a report link field report on your search target single record.
This report should show up on the Search table records or the table I wish to search in?
So you should be able to just edit the search record, save, and see the hits on the embedded report.
I would paste the string of values into the one text field here? Would they be separated by "OR"?
I appreciate the help.
- Make 1 field as a large text field data entry field.
So the Search table will have 1 field only, and it will be Text?
- On the search target table put a formula numeric field with a formula of 1.
I can make the formula field, but how do I make the value = 1?
- Make a relationship to the details table and lookup the search target text.
So the table I wish to search is the Parent and the newly created Search table is the Child? What should the reference field be? I can enter the Lookup field as the one field I created in the Search table.
- Make a report where the [search target text lookup] contains the search target field in the details table.
I don't understand this. Does this mean I should make a Table Report with the Lookup Search field and the field I wish to search in as columns?
Use that report as a report link field report on your search target single record.
This report should show up on the Search table records or the table I wish to search in?
So you should be able to just edit the search record, save, and see the hits on the embedded report.
I would paste the string of values into the one text field here? Would they be separated by "OR"?
I appreciate the help.