• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

Display contents of table as headings on form

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
Zbiebu
Asked:
Zbiebu
2 Solutions
 
AnuTijiCommented:
Hi

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

Tackle projects and never again get stuck behind a technical roadblock.
Join Now