General information
Category:
Forms & Form designer
Title:
Grid using two tables ?
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only