Jump to content

how do I search in multiple fields?


jimlongo
 Share

This topic is 5681 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5681 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.