Many data instead of only one.

[George]

Hi, here is an exemple.
I have a table with 3 column:
1- Manufacturer 2-Product 3-Representant

A manufacturer associate with a product may have many
representants.
I could make a row for each of the representant but there
is a problem when i search info. It is that if I search
the products and representents of a manufacturer, instead
of having a row that shows the manufacturer-product-list
of Representent, it will give me as many row that there is
representant.
Note: The reprensentant is not reprensenting all the
company product.

Thanks

 

[Steve Schapel]

George,

With this data structure, a Select query will do exactly as you have
described, i.e. it will return all records from the table which match
your criteria.

There are ways to concatenate, in a query, the values in multiple
records with a common value in another field. An example can be found
at http://www.mvps.org/access/modules/mdl0004.htm and another at
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

Another approach which may serve your purpose, is to simply make a
report based on your existing query, and set the Hide Duplicates
property to Yes for the Manufacturer and Product textboxes.