I'm not sure if this is the right place for this post, but maybe you guys can help. I have a table of products and a table with customers. Each customer offers up to 30 different products. I created a join table in access that pulls the customers and the list of products they offer. My question is, is there a way to construct a web table that shows the customer's name plus the list of products? I don't want to show the customer's name 30 times, just something like:
Customer A Name
and so on.
I'm sure this is rudimentary but it's driving me nuts. any help is appreciated.
You have no business even trying to do this in SQL. The problem you have is a formatting issue, and SQL is designed for producing results, not formatting results. Formatting is the responsibility of your user-interface or reporting application (Access, Crystal, Active Reports...whatever).
If it's not practically useful, then it's practically useless.