Display contents of table as headings on form

Posted on 2011-09-14
Last Modified: 2012-05-12
I have a list of customers and a list products. I need to be able to list the customers down the left side and to have the products in a row along the top, displayed like headings.  Is there a way that this is possible. Both lists come from a db table.  The list of customers on the left side is no problem, but getting the contents of the products list to display across the top of a form is causing the problem

                          ProdA           ProdB           ProdC          ProdD

Any help would be appreciated
Question by:Zbiebu

Accepted Solution

AnuTiji earned 250 total points
ID: 36535785

While getting the records from the database, if the database is "SQL" use a pivot statement to transform rows into columns
LVL 12

Assisted Solution

viralypatel earned 250 total points
ID: 36535791

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL syntax in 5 39
Get Client IP on RDS - VB.NET 15 47
VB.Net Tranfer data between to VB.Net apps 8 26
No Data for DropDown List 2 25
Introduction When many people think of the WebBrowser ( control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question