displaying all record fields in report

[mallikai]

I have 4.0 & 5.0

question...

I am using the program to invoice customers...My invoice records have customer i.d., date, labor, materials...

labor and materials are repeating fields...

I am interested in creating a layout so that I can look up all materials for one client in one form...

all i can do now is create a layout showing materials but it is separated so that each record for a particular client has repeating fields...

I was to create a layout so that I will be able to show all materials on one form for one year for one client (though the client may have 14 records with 10-15 materials on each record)

Also...when I try to export the repeated fields (materials) by tab or comma, if i open up in excel or ms word...the delimiter is not working and i get all records in one cell???

any help is appreciated...

thanks

p.s. windows 98 format

[danjacoby]

You have discovered why repeating fields are almost never to be used. They're a pain in the ... uh, neck.

Create a related file and use a portal. That way, you can create a sub-summary in the related file.