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.