Drag and Drop Records

M

Marcus Lloyd

Hi,

I need to create a relationship between two sets of data, Purchase Order and
Production Schedule Order.

I've reviewed many different ways to get this done but always come back to
manual intevention due to the two sets of data being different.

So, what I would like to do is create a form with two sub forms, both in
datasheet view.

The user drags a record from one datasheet to the other, which then updates
the two fields in the table being dropped on.

Just wondered, is this possible? and if so got any pointers on how to do it...

Thanx in advance

Marcus
 
Top