I'm thinking this is gonna be one of those.."I was dumb not to think of that" type of moments.

What I'm trying to do (if possible) is go to a record based on the result selected in a drop down box.

I'll set the scene: On my clients form, in the header, I have a drop down box which has a list of my clients. When the user selects a client from the box I want it to show that record.

I can do this easily through a Find script but I don't want to filter, I just want to go to the appropriate record.

I thought it was going to be a using something like Go To Record... but doesn't seem to be right.

Any help will be cool. Thanks

Well I think I must be getting the hang on this FM stuff. I seem to be working things out myself eventually once I work out what each script step actually does.

For those that are interesting, I did end up using a Find script. I could shorten it but we'll see how it goes. How I've done it:

Enter Find

Set Field to the global field I have

Perform Find

Show all records (this was the step I didn't have - you stay on the record you've found but show all the other records so it looks like you've just gone straight to the required record)

Set Field [global field to ""] this just removed the id number that would stay there since I'm using a drop down list (so I can type the first letter to scroll the list). If I was using a pop-up I probably wouldn't do this.

Try this out. I still couldn't figure out placing the menu on the customer page?? But got it to whee you can pick from the drop down and go to the related record.

test3.zip