please help again!!!

[choti]

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

 

[ian_ok]

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

 

[Rich]

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