>>>So far, i don't see problems. You collect one-many tables to one cursor with >ProviderID,AddressID,TaxID ... Now you can just order this cursor by this 3 >fields providing that empty AddressID will go last.
>>
>>Two problems with this approach. 1) I think that after I get the final address break the detail lines will print all of the TaxId's under one blank address, correct? I need to print each TaxId as if it has a seperate address.
>
>You can just print some word like "missed" or "unknown" for each empty address.

Well they haven't really been missed though. It would print

address
taxid
taxid
taxid

address
taxid

blank address (or unknown)
taxid
taxid
taxid
taxid

What I'm trying to achieve is

address
taxid
taxid
taxid

address
taxid

blank address (or unknown)
taxid

blank address (or unknown)
taxid

blank address (or unknown)
taxid

blank address (or unknown)
taxid

>2) for brevity sake (well, I did try anyway) I didn't detail the other parts >of the report. It also has to print provider specialty codes and state >licenses in a seperate section/format. Using your approach would associate >specialties and licenes with a particular address, not with at the provider >level. In other words the specialties and licenses would print each time an >address prints.
>
>Again, if you break it by all three fields, it should work Ok.

Hmmm...lemme check that, off hand that sounds like it might work for me.

THANKS!

...kt