Do you want to find a record that has it in any of the fields?
If so you can try
Enter Find Mode
Set Field [Field1;searchstring]
New/ Record Request
Set Field [Field2; Searchstring]
Set Field [Field3; Searchstring
Also, typically when dealing with a structure where you have like fields such as Name1, Name2, Name3 is indicative of poor structure. Instead you should use a related table with each name being its own record.
Ok. How would i go about setting that up? Do i need to use a portal? I've had trouble getting the hang of 'related fields' and 'portals'. Would you be able to refer me to any good guides or tutorials in order to set that up? I kind of knew that my structure wasn't quite right, yet i just haven't been able to figure out the portals/related fields.
thanks in advance for your help. it is greatly appreciated!
The initial tutorials / guides that come with the system and the documentation from the website shoudl be a good start. Picking up a book such as the Missing Manual would help as well.
You will also want to read up about data normalization.
Once you have those in a seperate related table, you should be able to find things easier.