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

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