General information
Category:
Forms & Form designer
I have a grid with Grid1.RecordSource = "Table1" Then I have each Grid1.Column1.Text1 = Table1.field1 and Grid1.Column2.Text1 = Table1.field2 and so on...but I want a column's text to display fieldn from a related table. That is, right before loading the grid I setup the two tables with a relations command: SELECT Table1 SET RELATION TO fieldn INTO Table2 ADDITIVE
This relation works great for my report, just not in the form. My ControlSource for the Grid1.Columnn.Text1 for this related table just has "table2.fieldname".
References in a report will pull in the related table but not on the form for some reason.
Is that clearer?
Doug
Previous
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