in my db i have a restaurant table which has fields such as name, street, town, postcode etc. there is another table (contacts) which has phone, fax, email as fields. the relationship between this is 1-many. if i run a query of restaurant and contacts, the same restaurant may appear as many times as there are contacts
eg macdonalds - 020 89535522
macdonalds - 020 89654444
macdonalds - 020 86542222

how can i design my query so that the name appears once with the appropriate numbers. i am using the query for asp so do i design the query to show the correct results or is it in the asp page??

much appreciated

choti

ps i want an output such as :

macdonalds 020 895554444
020 895554443
020 893555111

Why not just enter macdonalds in the Query section untick the show box and save your query as macdonalds.....and you have the numbers of macdonalds.

I know what you want, but this is difficult as I know, Rich or Pat may be able to tell you an answer.

HTH

Ian

I've not done any work with asp so any help offered maybe irrelevant, a single query displayed in datasheet form will not display results the way you want. A form/report will.
Add a textbox to the header which displays the unique name you want, drag the query into the form and link by the name/ID field, hide the field on the sub. You can change the text box to a combo and just requery the sub to display all no's listed for each company.
HTH