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
ZbiebuAsked:
Who is Participating?
 
AnuTijiConnect With a Mentor Commented:
Hi

While getting the records from the database, if the database is "SQL" use a pivot statement to transform rows into columns
0
 
viralypatelConnect With a Mentor Commented:
0
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.

All Courses

From novice to tech pro — start learning today.