I have a table called “Client” with multiple fields, including “FirstName” and “LastName”. I also have another table called “Transaction” that is also referenced in the Client table. The relationship is one-to-many (each transaction can have multiple clients).
For displaying the data on my screen, I want to display the first and last name of all clients associated with a particular transaction. So the query is simple: where Transaction = Transaction (which will return multiple client rows) but I have no idea how to display the first and last name of all clients in one line. So my display should look like:
Client1FirstName Client1LastName & Client2FirstName Client2LastName & …
Thanks in advance