Solved

Display contents of table as headings on form

Posted on 2011-09-14
2
219 Views
Last Modified: 2012-05-12
Hi,
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
CustA
CustB
CustC
CustD

Any help would be appreciated
Thanks
0
Comment
Question by:Zbiebu
2 Comments
 
LVL 4

Accepted Solution

by:
AnuTiji earned 250 total points
ID: 36535785
Hi

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

Assisted Solution

by:viralypatel
viralypatel earned 250 total points
ID: 36535791
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

758 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now