SET FIELDS CONFUSION

[TrueCode]

I have a generic form that I want to use in cases where my user has to visual inspect and select search results. The form has a grid that pulls from the underlyping results table. I want to use set fields to place the fields on the table in the order that I want them to appear on the grid. I don't want to individually code the column of the grid to achieve that.

when i use set fields to field1,field2 etc it seems to affect the other tables in other work areas.

Please help.

I have read the help and am still confused.

 

[SqueakinSweep]

truecode

It certainly shouldnt behave this way.

As a workaround, why not select all the data from your table into a cursor, and tie the grid to the cursor instead.
You could also just select the fields required, instead of using set fields.

eg select field1,field2 from TABLENAME into CURSOR crsGrid



WTrueman
...if it works dont mess with it

 

[TrueCode]

Thanks Trueman

It worked, I mean with your suggestion.