Jump to content
Sign in to follow this  
gianata

Performing a search on multiple fields

Recommended Posts

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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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