Copy Paste help

[NewbieHere]

Hello all

I have two fields Customer_::Phone AND Invoice_Old:: Phone. What i'm looking for is a copy and paste script. Copy everything from field Customer_::Phone and paste it into Invoice_Old:: Phone. There are no portals. I'm sure this is simple but for some strange reason I'm having a great deal of difficulty.

Thanxs

[MoonShadow]

It would be easiest to let the relationship between Customer and Invoices handle this for you. I assume they are related on the CustomerID? If so, add an Auto-Enter via Lookup to your Invoice_Old::Phone, selecting your Customer_::Phone.

If you need to pre-fill existing records, you can loop script it or use Replace Contents. Is this a one-time thing or a recurring process?

And please delete your duplicate post in vs. 5/6. Not only is a duplicate post unnecessary but the other one is in the wrong section since you've indicated you are using vs. 7.

[NewbieHere]

good point

[Søren Dyhr]

Moonshadow didn't touch the dodgyness with copy and paste in this context. Thou must never ever touch what the user might have in his/her clipboard - use Set Field, autoenters, references over the relationships according to your needs. The clipboard is only ment for interapplicational maneuvers - not filemaker/filemaker stuff, say the clipboard contains a unique occurence of a holiday picture or soundclip....

--sd