Grouping a recordset?

[Paulsburbon]

I'm not sure how to phrase my question but I'll give it my best shot.

I have an order table with a details table. At some point a user must assign a vendor to each order detail in order to send out Purchase orders. I was thinking of using SQL insert statments to create the purchase order in it's table along with details but how do I program grouping if two or more items belong to the same vendor?

I usually have been using adodb.connection begin transaction to do updates of this sort but I've never had to look to see if there was a common value in the table.

 

[Paulsburbon]

So thinking about this. I think I'm going to use a select distinct SQL statment to get all the vendorIds in a list. then loop thur that list by pulling all Order details under that order AND that vendor ID then create the PO that way. I would still like some input if that is not the best way. Thanks!