[VB] - ListView Drag and Drop
 

I've got 3 database tables:
accounts
groups
links

accounts and groups both store top-level header information. The links table links the accounts into the groups on a many to many basis.

So what I want is for the user to see which accounts are in which groups(done), and also for them to drag the accounts from one group to another.

I've set up a form with a TreeView displaying the groups. Clicking on a node loads the attached accounts into a ListView.

I've got a second pair of TreeView and ListView controls underneath. What I want to do is to let the user drag an account from the top view and drop it into whatever group they want on the bottom view (or vice-versa). Of course, I need to perform all the appropriate sql to edit/add rows into my links table, but it's the actual implementation of the Dragging and Dropping that I can't seem to get my head around.

Has anyone done anything like this who can give me some tips?

Ahh it's ok, I figured it out - I used the OLEStartDrag and OLECompleteDrag events.
First I stored the indexes of the selected data in a global variable, and then sent it back in on the CompleteDrag event.