A quick Google search turned up this KB related to your issue.

http://support.microsoft.com/kb/914595

That looks like it should work. I will test it and let you know if I have any issues.

Thank you so much for your help!

Update:

one syntax error. I added a...

Correct. C_Custno (PK for Agent Table, FK for Client Table) A_Fname1 A_Lname1 - this is the grouping or parent

CL_Clino (PK for Client Table) CL_Fname1 CL_Lname1 CL_Incdt

CL_Clino (PK for Client...

Ok I have included what I think you are asking for. I have also attached the Sample Data and Desired-Output in separate files.

Field definition

c_custno(char(5), not null)

a_fname1(char(20), not null)

a_lname1(char(20), not null)

cl_clino(char(7),...