i have created a form with a datasheet subfom with a 1 to m relationship. i believe i set this right from the sample database here as well as in other sites. My problem is in the reports, how come that everytime i add a new data in a data sheet subform, in my reports my details get repeated in every new euipment?
Here's what i want in the report:
item item Description qty category
1 xray 1 medical
2 ct scan 1 medical
3 chair 2 non medical
Sadly, this is the outcome in my report:
item item Description qty category
1 xray 1 medical
item item Description qty category
2 ct scan 1 medical
item item Description qty category
3 chair 2 non medical
How can i resolve this? i search in google as well in yahoo, but with no luck ( i guess my searching skills sucks). sorry for asking so many noob question , cause im near in my project completion.
thank you in advance
archie