Turner999

Tricky problem.

I have three tables: Order, OrderDetail, and Product.

An order can have many OrderDetails, and a Product can be on many different orders. The OrderDetail table just has the OrderID and productID, so there is essentially a many-to-many between order and product).

I have a form for the user to enter a new order. I want to have an unbound box that contains the names of all the products, and to be able to drag these names into a box under the order, to add a new OrderDetail record using the productID of the dragged order along with our orderID.

Is this drag-and-drop addition of records possible?

thanks.

martonx

Interesting question. I never tried before.