[RESOLVED] Reporting help
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.