Go to specific record.

[Mike CPB]

At the moment I'm a little stupmed as to go to a specific record.

I have RecordID field with auto serial number.

Whit the scripts that I've made so far they do find the record. But searching "1" brings up any record with a 1 in it.

Is there something I'm missing? Maybe perform find isn't the way to go.

I'm sure this issue has been coverd before, but my search's have been fruitless.

Regards, Mike.

[Mike CPB]

Trying to go to a related record between tables. Mainly returning to specific record from the second table.

Main table is clients with relationship to complaint tracking. Durring the script that creates a new complaint record it copies the RecordID and that activates the reference fields and ready for user imput.

I'm a little interested in Get(RecordId) as a global variable but not sure how to go to that record.

Regards, Mike.

[Inky Phil]

Hi Mike

If I understand you correctly you just want to return to the record in the first table once you have visited the related record in the second table.

I would do this by going to my related record in another window and once finished just close that window and go back to the original window where you should find that you are still on the original record

Hth

Phil