Jump to content

Performing a search on multiple fields


gianata
 Share

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

Recommended Posts

  • Newbies

My problem is this:

I am creating a simple database that contains a grid with seven separate codes (in 7 separate fields) and the numbers (in adjacent fields) that correspond to them. All numbers are distinct and should be kept separate.

Can I perform a search that will locate a specific code in one of the seven fields? If so, how? If not, is there a solution to this -- perhaps creating a composite field that will display the contents of all seven fields in one?

thank you for your help

Link to comment
Share on other sites

Without a clue as to why the seven separate codes would be in separate fields ('cause having one code field would simplify things)...

Create a global field.

Create a script that:

> Goes to find mode, and to a layout that contains only the global field

> Pauses so the user can enter the code in the global field

> Copies the global field & clears it

> Goes to a layout with all 7 code fields

> Pastes into the 1st code field

> Creates a new request & pastes into the 2nd code field (repeat this step until all 7 code fields have the same data)

> Performs the find and

> Returns to the original layout

Link to comment
Share on other sites

This topic is 7170 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.