grouping difficulty

I have a couple of records with orderrows (either boats or articles) :

order = 1, obj = boat1, objkind = O
order = 1, obj = artcl1, objkind = A
order = 2, obj = boat1, objkind = O
order = 3, obj = boat2, objkind = O

How do I get?

boat1
order 1
boat1
artcl1
order 2
boat1
boat2
order 3
boat2

Regards
Harry

Comments

  • edited 10:16AM
    should be:

    How do I get?

    boat1
    ---order 1
    boat1
    artcl1
    ---order 2
    boat1
    boat2
    ---order 3
    boat2

    So the first group should contains info that's also in the details when it is a boat

    Regards,
    Harry

Leave a Comment