Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid using two tables ?
Message
From
04/05/1998 10:32:25
 
 
To
04/05/1998 10:24:46
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00096705
Message ID:
00096709
Views:
21
>I need a grid to display info from two related tables. i.e.
>
>a.custnum,b.custname,a.invoice,a.cknum
>
>In the Data enviroment, I have set up A and B with a relationship from a.custnum to b.custnum
>
>In the Control Source for each grid text object, I have selected the appro. field in the control source.....BUT....when I run the form, I get the first four fields from table A, but nothing from table B. I know their has to be an easy way.....Can anyone help?? Thanks in advance....Tim Ard

You should specify ControlSource for each column. Also, note that normal way is to use View/Cursor and forget about temp relationships.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform