Retrieve position of field to return to the field

[michele]

Concerns: Filemaker 8 for use on pc

What I need is a way to return to a specific field.

If I may compare my question with Excel, I need to store the reference to my cell.

Which would be in this example B9, or G4 or....

So I've used

Get(Activefieldname) and Get(Recordnumber) to retrieve the position of my field.

Now here's the problem. Going to the record number is no problem as the "go to record" script step allows me to specify "by calculation" (where I can refer to the value I stored using Get(recordnumber).

But how do I go to the right field? I've stored the field name retrieved with Get(Activefieldname) but "go to field" doesn't allow me to refer to the stored field name.

What functions or script steps should I use to be able to go to a specific field and then to a specific record number within that field.

The position of the record will vary, so I can't give a 'fix' fieldname.

Thank you for helping me out.

[Lycanthrope]

I haven't tried this myself, but in theory it should work.

Freeze Window

Loop

  Go to Next Field

  Exit Loop If [Get (ActiveFieldName) = YourField]

End Loop

The reason for freezing the window is so that the user can't see what's going on and to help speed up the script if you have a lot of fields to cycle through.

Hope this helps

Tim

[Genx]

You might want to throw in a not isempty(YourField) check at the beginning.

[IdealData]

I think the loop only works if the target field is part of the TAB sequence.