ctiger2

Vaughan...your suggestion for creating Global fields was indeed the perfect solution I was looking for. I thank you very much!

Thx Vaughan! I will give it a try when I have some time today.

Does anyone else have experience writing a script to copy field(s) from one table and paste them into field(s) on a second table without creating records in the second table? Just a simple copy/paste script.... Setfield works within the same table but not between tables. I have attached my work in progrss. Not having any luck so far and becoming frustrated... db.zip

Doug, Thx for your response. I beleive you are on the right track. However, I do need to be able to copy/paste these fields without creating records in the second database... I will keep hacking away...

Hi Guys, thx for the responses. Synchronization is definitely not what I am after here. Basically, I have two databases. There are (X amount) of fields from database 1 that I would like to copy/paste into (X amount) of fields on database 2. Exactly like a Set Field [db1::field1; db2::field1]. I have attached a file for reference in my first post. I beleive I have all the relationships setup correctly. I just need to know what I am missing here script wise. Thx for your help.

Hmmm...OK thx for the info. I find it hard to beleive that a copy/paste script between two databases is not possible. This is really what I want to do. Syncronizing may have been the wrong term to use...

I am a newbie to FM7. I have two databases and I need to be able to perform a script that copies/or sychronizes fields from on to another. (For Ex. db1 table 1 field 1 to db2 table 1 field 1.) Is there a script that can do this? Or, is there a relationship I can set to have the fields automatically be synched depending on what record I am at? Thx for any info... db.zip