Cross tab query type reports aren't as easy to set up in Filemaker as you can in MS Access, but it can be done.
You have to use relationships and either multiple portals or multiple relationships with calculations that reference data for each column.
Can you post an example of how you want to set up this "cross tab".
I'm picturing the following but could be wrong about what you want:
01/01/2009 12345 Item1 Item2 Item3
01/05/2009 12346 Item1 Item2 Item3
Yes, you are correct except I would like to be able to stack the data such as:
Thanks so much for your quick reply, I'm afraid I'm a bit too inexperienced with FM to use either multiple portals or multiple relationships with calculations that reference data for each column, could you point me to some reference material or give me an example?
Hmm, that's actually quite different and opens another possibility that may or may not work for you.
What if you based your layout on your line items table and set up the layout to print in more than one column? The result is only visible in preiview or printing but is quite simple to set up.
To set up a layout for multiple column printing, enter layout mode, select layout setup... and click the printing tab.
"I'm a bit too inexperienced with FM to use either multiple portals or multiple relationships with calculations that reference data for each column"
If we end up using one of those methods, I'll try to walk you through it step by step.
Phil, sorry for the delay, lost in the holidays. Thank you for your help, I was able to show my client the advantages of normal rows and columns ... thankfully. I do understand your method listed above though and I will keep it in my arsenal for future use. Thanks again.