Display contents of table as headings on form

Posted on 2011-09-14
Medium Priority
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 1000 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 1000 total points
ID: 36535791

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…

586 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