Multi-Tables in a Grid?

[fmoore0001]

Guys, it is possible to have more than one table in a grid. I have a situation using VPF 7.0 where displaying the data would be very handy from two tables and NOT creating a cursor.

Please let me know ASAP. May have to consider that cursor option if naught else.

Frank

 

[BeautyLover]

I think it is possible. Look at tastrade order entery form. The grid has 2 colours (sections) Each section is reading from a table.

 

[fmoore0001]

Where do I find that?

 

[craigsboyd]

fmoore0001,

Yes it is possible. One of the tables needs to be the recordsource for the grid and the others need to be related to that table. A couple of things to look up in the helpfile and do a keyword search on this forum:

SET SKIP TO
SET RELATION TO

...if you still can't get it after that then post back and either myself or another member will help further.

Slighthaze = NULL
_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[ramani]

Hi

Example....
**************************
USE HOME(2)+"\DATA\Orders" IN 1 ALIAS orders
USE HOME(2)+"\DATA\customer" ORDER cust_id IN 2 ;
ALIAS customer
SELECT orders
SET RELATION TO cust_id INTO customer
LOCATE
BROWSE FIELDS customer.company, customer.city, ;
orders.order_amt
***************************
Now in your Grid, insted of browse, you can use the fields in your grid.



____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

When you ask VFP questions, please add VFP version.