Main/Sub Form Exports to Excel??

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

I appreciate this may look a little OT at first but I thought this newsgroup
may be the right starting point.

I need to output main/sub table data to a spreadsheet where the data that is
in the main table occupies the first several columns and the data in the sub
table occupies the remaining columns to the right. The net result is that
the first several columns contain repeated information and the resultant
output is far greater than I need.

Has anyone found a way to output the main table into the top rows/cols of
the spreadsheet and the remaining sub table data into rows/cols underneath?

Regards.
Bill.
 
Bill,

If your data / table structure is what is implied by your "sub table" term,
then you have a one-to-many relationship. Trying to display related data in
a spreadsheet is sort of like trying to put a 3 dimensional object onto a
piece a 2 dimensional piece of paperr. When you really put all of the data
(each record shown with all related records) you get something that is big
and hard to read and which you got and called "too much data".

So now you have to decide EXACTLY what you want to see with respect to
showing one-to-many related records.

If you want to see each record on the "one" side shown only once, and then
all of the records related to it underneath of "next" to it, then you need a
grouped report, where the "one" is the group header, and the "many" is in the
detail section. Anothe choice might be to just how the two tables
independently with no attempt to show the relationship between them.
 
Back
Top