I am trying to design a couple of one-to-many reports. The data environment for the first report will be made up of views that select records from FPD26 tables. The parent view is "nameplatv" and the child view is "dgav". These views are in my database container to select records from the FPD26 tables "nameplat" and "dga" respectively.
How do I establish the one-to-many relationship between the two views based on "custid+upsino", which are fields in each view? Do I have to do this programmatically? And which method of the dataenvironment do I place the code in?
The second report I will design will use the same parent view but multiple child views. Will I do the same thing there?
Thanks
Elgin