Displaying subsummary parts horizontally
Please bear in mind that this may be a stupid question but I'm going to ask anyway. I have a series of invoices that I currently have displayed based on due date, then by invoice number, finally the items per invoice as below, the invoice date and Invoice number are in one table, the line items are in another related table.
01/01/2009 (this is in a subsummary part)
Invoice #12345 (this is in a second subsummary part)
Item1 (these are in the body)
I would like to display these horizontally across the screen instead of vertically, could I please get some help in how to do this before my head explodes :-), I'm certain it is something silly I have overlooked. I used to be able to do this in Access as a cross-tab query but filemaker has me baffled.