Data Entry: Drag and Drop (one to many relationship)

[WebFaktor]

Greetings,

OVERVIEW: I am in the process of developing an Access 2000 'prototype' database that will eventually be modified to become accessible over the Internet. The main functions my database will provide it users is the ability to enter and subsequently manipulate data.

QUESTION: My client is requesting that I devise a drag and drop feature for the data entry aspect of the database. More specifically, a drag and drop feature that allows the dragged and dropped selections to become the many side of a one to many relationship. Is it possible for me do develop this type of data entry feature within an Access 2000 database, or would I need wait and develop it later whence the database is modified to become accessible over the internet?

I would very much appreciate direction on this matter.

Sincerely,

WF

 

[afloyd]

I think your base problem is going to be how are you setting up your initial table relationships and what are going to the key(s).

As long as you can drop the dragged item into the "many" table, I don't know why it wouldn't work. It would consist of moving the data from the initial table it was stored in to the new table. That is probably going to be a SQL function.

I hope that makes sense.

 

[WebFaktor]

Issue Resolved

I found what I was after through a 3rd party vendor. I chose the drag-N-drop application made by Peter's Software as what they offer seems to provide the sophistication I was after. For me to have devised something similar would have been impractical given the small expense they charge.