find, pop-up menu, link to 1 of 6 layouts?

[wilse]

Hi all

I have a slight predicament... with the help of this forum I have managed to create my project, practically to the end... apart from the find feature.

To summarize, this is what I'm struggling with:

I have defined a field called "model number", I then use a calculation field, to turn this to CAPITALS for 1 of the 6 layouts (FRIDGE, OVEN, DISHWASHER, FREEZER, HOB and HOOD).

I would like to create a find page, that can search for "model numbers"

and when the user clicks on the model number, this will link back to 1 of the 6 layouts...

can anyone offer any help, or advice? please

Az

[djgogi]

From top of my head:

After performing find

Go To Layoyt [layout number from field LID]

Where LID is calculated to match the right layout for given models.

Also layouts could be rearenged and grouped (LID might have some offset) , in order to make the process easier to control.

Dj