InfoPath Dev

Hi all, Is it possible to combine 2 sharepoint lists into 1 data source by using 1 list as the column names and another as the rows? Even doing it exclusively in SharePoint would be useful. e.g. have a list of customers in column A from a contacts list and a column for each product from a product list I know I could just create another list manually but I'd like to avoid having to keep things in sync when a new product or new customer is added to either source lists? Michael p.s. I tied the SharePoint 2010 linked data source but the wizard wouldn't let me associate my own key column and tabular views wasn't an option

I am trying to think of this using SharePoint or creating a form and publishing it in SharePoint.

If I have a list of contacts and a separate list of products, how do I  know which product goes with which contact? In other words if I create a list (form) with all my contacts as column headings, how do I know which product goes under which contact (column)?