All Information on one Line

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

Hi,

I have a one-to-many relationship going between two
tables. I am trying, on a report, to show the multiple
records for a specific record all on one line.

ie: Main Table "Family Name"
sub-table "Father
Mother
Sister
Brother"

Would like to be able to printout like:

Family Name: Father, Mother, Sister, Brother

Appreciate any help.
Jimmy
 
Hi!

Try this in the row source of the textbox:

= [YourTableName.Father] & ", " & [YourTableName.Mother] & ", " &
[YourTableName.Sister] & ", " & [YourTableName.Brother]

// Niklas
 
Back
Top