display field in another table instead of grid column data

[slmamd]

hi ..all
need help please

grid usually display records line by line until get end of the grid window...

i am wondering if there is "event"(method) could i use before display next line , then i can manage how would i display the field from another table instead the one already in the grid column (grid has tied table) ,,

hope the image is clear to u...

appreciating u make small code as example ,,,

thanks

 

[bborissov]

Check all Dynamic* methods.
You could use one of them to manipulate grid contents.

Borislav Borissov
VFP9 SP2, SQL Server

 

[Mike Lewis]

The usual way to do this is to create a cursor that contains the fields you want to show in the grid. Then use that cursor as the RecordSource for the grid.

If you want to display fields from a second table, create a cursor that combines the two tables. You can do that with SELECT ... INTO CURSOR.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[slmamd]

thanks

...............bborissov.............
............... mike .............

now working fine .