how do I search in multiple fields?

[jimlongo]

This is a real newbie question, but I don't find it in the Help or searching the forum.

I have records that contain from 1 to 5 people

adult1 firstname lastname email dayphone evephone

adult2 firstname lastname email dayphone evephone

adult3 firstname lastname email dayphone evephone

junior1

junior2

junior3

junior4

How would I search to find a record that contains anyone with the lastname JONES or phone number 123-4567, keep in mind a record might contain, for instance, ONLY a junior1, or adult2 and junior1, etc.,

tia,

jim

[John Mark Osborne]

Take a look at the New Request feature. You'll find it under the Requests menu when you are in find mode. Basically, it allows you to add additional OR requests to your find.

[jimlongo]

I figured it should be easy.

Thanks again!

[comment]

It can be much easier, if you correct your data structure. You should have a separate table of People, where each person has their own individual record. Then define a relationship between People and your current table (Households?).

Otherwise you will encounter problems like this all the time - for example, if you wanted to send e-mail to every Adult, or just find out how many people are in your database.