updating two distinct fields
I have fields A & B in two different databases, X & Y.
I am hoping to find a way that when I create a new record in database X and add a new value in field A that the same process is automatically repeated in database Y and field B - that is, a new record is created in database Y with the exact same value in field B that was just added in field A in database X.
I have created a simple script that allows me to import the all of the records from database X with the contents of field A into field B in database Y , but was hoping that there might be another more efficient way to do this.
I do not simply want to map field A of database X to database Y.
Thanks for any help that you can offer.