not so easy sort!

[IEW]

I want to do the following:

copy part no from layout A

goto layout B

paste partno into layout B

do find layout B

quit find layout B

This sounds easy, but I am having trouble with it.

Ivan

[RalphL]

Do you want to find in layout B using the valuie you copied from layout A?

If so, do the following:

Create a global field of the same type a part no, probibly text.

Use Set Field to set the value of the global to the part number.

Go to layout B.

Enter find mode.

Use Set Field to set the value to the global field.

Perform Find.

That should do it.

[IEW]

yes

[IEW]

whats wrong with this line? global field will not change!

Set Field[quote::pnsrch; quote::pnsrch=quote::quoteno

Ivan

[RalphL]

quote::pnsrch=quote::quoteno makes this a boolean expression, true or 1 if they are equal and false or 0 if they are not. I don't think that is what you want. The set field has two things that must be specified, the field to be set and the value to which it is to be set.

I think you may want : Set Field

[-Queue-]

Or create a relationship between the tables, based on the two fields, and use Go to Related Record [ Show only related records; From table: "secondtable"; Using layout: "layoutAssociatedWithsecondtable" ].

[IEW]

Ralph:

Your right. it returns 1 or 0. I tried it as you wrote it and it will not set the global field. It will set all other fields.

Ivan

[RalphL]

Send us your complete script. Setting a global field should work.

[IEW]

There seems to be a problem using Set Field between tables. It works when your in the same table. Won't work between tables. I Set a relatioship between the two tables and that did'nt help.

Ivan

[-Queue-]

Are you trying to set the field in Find Mode? Relationships don't exist in Find Mode. But you shouldn't need a relationship to set a global in version 7 anyway.