"Keyword" as part of a Relationship

[bonngo]

I have a multi-relationship set up between two tables. The last piece of this relationship is to allow the user to type in "keywords" into a global field that is related to a text field in the other table. Of course setting the relationship to "=" results in no match. I guess what I am looking for would be equivalent to a "contains" sort of relationship.

Any assistance would be greatly appreciated.

[bcooney]

less than or equal to

[mr_vodka]

If in your child table you can create a Stored calc that is a Substitute (textfield; " "; "¶") and in your parent side a calc that does the same Substitute (gSearch; " "; "¶")

Then if you type in: 'blue green', it will return all the records in the child that have either the word blue or green in the textfield.

[bonngo]

Thank you very much! Just what I needed.

[bcooney]

Oh, I read that post too quickly, and didn't realize that your were trying to filter on more than one word. Thanks for catching that one, Mr. V.

[bonngo]

Mr. V

I am trying to think of a way this could be a boolean search. Without having to go into find mode. The application I am building will be IWP and the toolbar is hidden so the user does not have the search options readily available. I did what you suggested and it worked great.

[mr_vodka]

You should be able to just use go to related record without going into find mode.