Hi.
I would like to see my results on a master/detail report as follows.
I have created the relevant sql relation between the master/detail tables tbl_Customer & tbl_Customer_Notes
CustomerID CustomerName TelNo Notes
1 Bob Smith 11111 Called and left message
Tried again today but he's on holiday
I'm getting the impression he's avoiding me.
I've had a brick through the window with a note.. stop calling
I've tried again but he's in hostpital with stress.
2 Pete White 22222 Called today about a new product
He's thinking about it
i think he's not interested.
he's giving me the run a round.
3 Doris brown 33333 She's in the market for a new product.
She's coming in next week for a brochure and a chat.
no joy, she found cheaper alternative.
But instead the reports aren't grouping, and displaying like :-
CustomerID CustomerName TelNo Notes
1 Bob Smith 11111 Called and left message
1 Bob Smith 11111 Tried again today but he's on holiday
1 Bob Smith 11111 I'm getting the impression he's avoiding me.
1 Bob Smith 11111 I've had a brick through the window with a note.. stop calling
1 Bob Smith 11111 I've tried again but he's in hostpital with stress.
2 Pete White 22222 Called today about a new product
2 Pete White 22222 He's thinking about it
2 Pete White 22222 i think he's not interested.
2 Pete White 22222 he's giving me the run a round.
3 Doris brown 33333 She's in the market for a new product.
3 Doris brown 33333 She's coming in next week for a brochure and a chat.
3 Doris brown 33333 no joy, she found cheaper alternative.
Any ideas ?
Thanks in Advance.
Chris
