I have a database with names and cities of persons (all in one table). Names can be the same, but if that's the case then he/she lives in another city (so the name AND city are the primary key).
How can I show the results of a query(DAO) in a dbgrid, so that if the name is the same they occupy one row in the grid instead for each double name a new row, so that you have a name and after the name, the city (next cell) with all the cities the name is present? for example:
NAME CITY
Johnson New York, Boston instead of:
NAME CITY
Johnson New York
Johnson Boston
Thnx in advance:)
