I am guessing that there is another data field in your table that shows where the person is employed (company) and this is duplicated for a company record.

Can you please clarify exactly what this set up is.

 

People(Table)               Casid(Table)

 

----------------             ----------------

CaseId                          CaseId

First name                     CCT

Lastname                       Status

Ctype                             DTIme

etc.....                              etc.....

 

People

Count

Casid

Boat

 

they are(relationship) connected to each other by (CCN-Case Number)

and People tables fields (First name , Last name(which include crew member-company name) and other fields.

Yes  both james and Jim are asscoiated with the Lone Star Company.

No there is no rows of data that link them or identify them as being togther.

 

I wouldn't think that it would be too hard in a stored proc as you can create a temp table that you can add names to probably by selecting records from the table where the name exists in the record you want...but doing so in CR would not be as simple as you need to 1 get the record, then go back and read all the records again to find the matches...which is something that CR doesn't do.

 

I feel that a stored procedure to retrieve your reports data is the simpliest and best solution.

 

you might be able be make this work with a sub report by having the main report return a record(s), then linking to the subreport, and selecting all records where their name is found in the main reports name....but it would have to be an exact match (wild cards are bound to mess up the result)

 

again, as always (as DBlank knows), I say go with a stored proc.