asked on

Best method to transfer data from one database to another within the inbuilt scripting environment.

What is the best method to transfer data from fields in one related database to fields in another only using the inbuilt scripting.

I am creating a school database and have to transport values from a database called "behaviour level report" to a related database called "welfare record".

It is easy enough to transfer values between layouts using the copy, paste functions etc. however. the ability for one database to issue commands in an external database (related) appeares to be limited to basic functions such as "open file welfare record". From that point on you loose controle. I can't then copy specific field values into fields in this external database.

ASKER CERTIFIED SOLUTION

Mariano_Peterson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

naubrey

ASKER

Thanks for your reply
Apologies for the time. I was waiting for some more answers as your answer didn't quite fit my solution and I had to work it through.

Probably not the best solution however:
I ended up getting my result by

setting the value of fields to a global fields.

Using the "external script function" to paste in the values into the related fields.

Mariano_Peterson

Avoid pasting; it does not offer consistent behavior and is highly error prone. It is considered extremely bad programming practice to use copy/paste. Instead, use the set field script step.

Using global fields works fine, but creates the unnecessary overhead and inconvenience of having to add new global fields every time you want to transfer an extra value.

Good luck,
Mariano

naubrey

ASKER

Apologies for my use of the word paste. I am using the set function.
Thanks