Return fields from multiple records in a single textbox

[TonyD1016]

Good afternoon everyone,

I'm working on a new project that tracks court letter updates.

I have two tables currently, one that holds client information (Name, Address, Attorney contact info), and a second that holds the court information (Docket number, Judge, court date, etc.)

I've set up the Court info table to have each docket number as a new record, and have the ClientID as a foreign key to the client table in a one to many relatonship.
My query returns the most recent information for each client by looking at the court date, and also indexes the judges name to display a client twice if they have a pending case with more than one judge.

My question is, given the two indexes of ClientID and Judge, is it possible to display all dockets numbers in the table that match those two criteria in one textbox in a report? For instance if there are six docket numbers in a table for Client A-- four for JudgeA and two for Judge B-- can I have the report display:

ClientA | JudgeA | Docket 1,2,3,4
ClientA | JudgeB | Docket 1,2

 

[TonyD1016]

That's the link I would have given you as well, but was trying to talk you out of it as a method of data storage. I didn't realize this was just for display.

Great. Thank you again.
I apologize for all of the confusion and I appreciate all of the help very much.

 

[JonXL]

The specific need at hand is to have a way of displaying the contact information for each individual ClientID in one report alongside all of the docket numbers associated with that ID in the related to that client.

If this is just for a report, you can do this with a group/summary on the report and this is built-in functionality that doesn't require code.

Create a grouped or summary report - Microsoft Support

Create a report in Access that groups data and displays subtotals, averages, and other aggregates.

support.microsoft.com