Creating a Graphical Interface to Map DB Fields

[kimosavi]

Hi,

I need to create an interface that will help user map fields from one database to another. The field names in one database will be constant, but the others will change.

Database1 Database2
FN1 Customer
FN2 CustomerID
FN3 CustomerAddress
FN4 CustomerSSN


I wanted to create something that will resemble a drag and drop from the fields in DB1 to DB2 or viceversa and a like will be drawn from that mapping.

something like this (sorry for the poor graphical representation):

Database1 Database2
FN2 -------> CustomerID
FN4 -------> CustomerName

(Lines should cross or overlap each other like a regular matching process)

So FN2 <<>> CustomerID will be mapped
and FN4 <<>> CustomerName will be mapped

Any help on how to approach this (or any other method) will be appreciated.

Thanks in advance!

Kimo