jshulse
Posts: 9
|
Posted: 11/17/2011, 1:47 PM |
|
I have a master file that contains company names. I also have 2 detail files, 1 contains the states that the company does business in and the other has the products they sell. I have created a query that pulls the data together such that I have multiple records per company based on the number of states and products. I want to search the query and if I get multiple hits on the same company I only want to display the company once in the grid. Any suggestions? I am using studio 4.3.
|
|
|
lboeldt
Posts: 53
|
Posted: 11/22/2011, 5:10 PM |
|
You could have the search form post to a report page. Then use the grouping feature and group by company name. This will display each company as a header for the group and all the subsequent details records below each group heading. Like this:
Company Name 1
Detail Record 1
Detail Record 2
Detail Record 3
Company Name 2
Detail Record 1
Detail Record 2
Detail Record 3
...
|
|
|
|