AnsweredAssumed Answered

updating two distinct fields

Question asked by rowing190 on Oct 13, 2010
Latest reply on Oct 14, 2010 by rowing190


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.