going to another DB, returning with information

[MsqedMan]

Probably another silly question, but.... here's the scenario

A technician is filling out the trouble report, and needs to create a requisition for parts. He hits the "New Req" buttion, which sets a global with the form # he is currently in, and auto sets that information in the new req form. After the Req form is filled in, he commits it for approval which sets a global with the req # and returns to the trouble report he was in. When he returns to the trouble report, I would like the po req # he just created to autofill back into the trouble form.

I can figure out how to do this if the technician is always on the last or first record, but I am stuck if he is in some other record. All of the sorts and finds I've tried ask for a record number, and I can't figure out how to use the global field as a serch criteria.

Any help would be greatly appreciated!