Inability to go to target field

[Philip Jenks]

Sees like a simple problem, but can't solve it. My script in File 1 says:

Copy number in Field A in File 1

Go to related Record in File 2

Go to Field X in File 2

Paste number in Field X of File 2

For some reason the third step fails. The cursor won't go to Field X. The first two steps are fine, and the fourth one is too (because If I put the cursor in Field X and do Apple V, it pastes the copied number).

Grateful for any ideas.

Philip

p.s. I've read elsewhere tha one slution may be to add 'Exit Script False" to the script if the first script is triggered by a script trigger, but it isn't.

[dansmith65]

One script cannot do what you are asking; unless you are accessing File 2 via a Table Occurrence in File 1.

So, first off; how are you accessing File 2? Do you have a Table Occurrence in File 1?

[Philip Jenks]

Hi Dan

I'm not sure f the terminology, but I have a relationship between File 1 and File 2, using two date fields. So I'd suposed that the script could use that link to get to the related record in File 2, and then just paste the number in the correct field.

[comment]

Copy number in Field A in File 1

Go to related Record in File 2

Go to Field X in File 2

Paste number in Field X of File 2

If - as it seems - there is only one related record in File 2, you could it all with one step only:

Set Field [ File 2::Field X ; File 1::Field A ]

Not sure why you need two files anyway.

[Philip Jenks]

Ooh, that's an alluring possibility. I'll try it out now. Thank you.

It works! You've no idea how happy that's made me.

Thank you Dan.

Now all I have to worry about is how clogged up the rest of my system is with illiterate coding.