Set the relation from the Parent to the Child (use SET RELATION).
SET SKIP TO the Child
Set the Grid's .RecordSource to the Parent
Prefix the fields in the Column's .ControlSource with the appropriate alias (Parent or Child).
>I have done this before but took a lot of time and still not sure how I got it to work...
>
>Is there in easy way to have a primary table in a grid and also have some fields from a secondary table and have it link and show the fields properly from the secondary table based on the relation of the link of the first?
>
>Everytime I do this, it seems to either show nothing in the grid, show the correct fields from both, but only on the current record and duplicate the info all the way up and down the grid and refresh when the row changes, etc. I always get various results and have to play with this to get it to work the way I want it to.
>
>
>Can anyone explain to me the best way to do this? Is it suggested to add these tables to the data environment and link them there, or is it best to open them in code and link them that way? How do I get the grid to display correctly at all times?
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