Browse window vs. Grid

[volfreak]

In V2.5/2.6 of FoxPro, about the only way to simulate a grid (that I know of) was to create a browse window and define the fields to be displayed. This browse window could have columns from different tables all displayed at the same time as long as a relation was set between the tables.

In the VFP versions, I cannot find a method to have a grid look at multiple tables. Of course, building a table which the grid can use can take considerably longer than just having relations set as the where/joins take time to build the resultant table.

Does anyone have a possible solution so that the grid can use columns from multiple tables?

Thanks in advance for any and all help.

 

[rgbean]

In VFP, you'd normally set the recordsource to either a Query (SQL SELECT) or View on the multiple tables, depending on whether you want to be able to update the data directly in the Grid.

Rick

 

[jimstarr]

The grid can look at multiple related tables directly. Just set the ControlSource of each column to the table field you want it to contain.

Jim

 

[rgbean]

You are of course correct Jim. It's just I find that this often takes more code (or patience to do it manally) than I normally want to invest to simply display related table data - especially if there is any "filtering" going on.

Rick

 

[volfreak]

Thanks for the tips. That is good news.

I'll go back and revisit this. I tried previously to leave the RecordSource blank and set the controlsource for each column in related tables and nothing was ever displayed.

Thanks for the suggestions.

 

[volfreak]

Okay, I don't know what I was doing wrong before but it's working now. Thanks for the information.

Jay