I am almost done with this orders page. Thanks so much for the help so far. I did change the LookUp to Filter and changed the data table.
Last hurdle for me is that not all columns in table are displayed. The product fields are still empty. The difference with these fields is that they lookup to the products table. I didn't think this would be a problem as I thought it was just display the row table with no more problems.