I have two tables. The first table I am showing the customer's prices. The second table is the customer's ship-tos. I don't want to use subreports because of performance issues (the reports are accessed from other countries). I have been trying to use a list (which has worked for me in the past). I put both my tables in the list. I assign the Customer dataset to the first table and the list. I assign the ShipTo dataset to my second table. However, if I try to create a sort, the field list displayed is from the Customer dataset.
I have also tried using a table within a table. I get the same problem.
Am I missing something? Is there another way to do this?
Thanks for any help.