Hi,
I have a 1 to many table relationship.
[tt]
tbl1 tbl2
part# --->> part#
desc op#
op_date
[/tt]
I want to display the data like this:
tbl1.part# tbl1.desc tbl2.rec1.op_date tbl2.rec2.op_date
etc etc. (i.e. the 'many' record fields displayed on one line.
A pointer to how to do this will be very much appreciated.
One further point, each part# belongs to a 'category' of parts, whereby each part from a particular category has a pre-set number of ops and op descriptions.
I would assume that I would have to group by category in order for the op. numbers (and op# titles to tally) for each category of parts.
Can anyone point me in the right direction?
Regards,
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk
I have a 1 to many table relationship.
[tt]
tbl1 tbl2
part# --->> part#
desc op#
op_date
[/tt]
I want to display the data like this:
tbl1.part# tbl1.desc tbl2.rec1.op_date tbl2.rec2.op_date
etc etc. (i.e. the 'many' record fields displayed on one line.
A pointer to how to do this will be very much appreciated.
One further point, each part# belongs to a 'category' of parts, whereby each part from a particular category has a pre-set number of ops and op descriptions.
I would assume that I would have to group by category in order for the op. numbers (and op# titles to tally) for each category of parts.
Can anyone point me in the right direction?
Regards,
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk