Hi guys

I have three tables.

Jobcard, Comments,DescriptionOfWorkDone

In each of these tables i have a column called JobNo which is the relationship between the tables.

On the form i have the following textboxes. JobNo, customer,vehicle,date contact person which is saved into the jobcard table. Then i have 5 textboxes for comments so the user can enter in 5 different comments. I store those comments as well as the jobno number into the Comments table. This is my problem. i will explain at the end.

So now when the user enters in 5 comments in those text boxes and saves it.
The comments table will look like this.

JobNo Comment
1 test1
1 test2
1 test3
1 test4
1 test5

Which all works ok.

So heres the problem with the report

I have a all the fields from Jobcard table on the report and then the field(comment) from the Comments table.

the jobcard fields aren't the problem its the comment field.

When i display the report this is what i get

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test1

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test2

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test3

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test4

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments: test5

It duplicates everything. I would like it to report like this.

Jobcard: 1 Date: 1/1/1
Customer: jerry Contact: Mark
Comments:
test1
test2
test3
test4
test5

Please can someone help me with this.