I think you need to take a closer look at how relational databases work. The idea is to set up your database so that such data does not need to be copied from one table to another in the first place.
Fields with names that number them 01, 02,... 10 suggest that you can probably use a portal to a related table. Whether or not this is the case, it is possible to design your database so that when you enter or select data in these fields, you are actually editing the data in the fields you show on the other layout--no need to copy them over and then delete from the original at all.
I got it to work! It works great! I did have to rethink. Thanks.
I have a script that triggers on object modify.
The script looks to see if the "title" field says "Lighting" if it does it sets the field "DesName" to what's in the field "name"
There is the possibility that there could be two "title" fields that say "Lighitng" if this happens I would like the FileMaker to keep the first record already set to the "DesName" field in that field.
Is this possible?
You'll need to describe what you have designed here in much more detail before I can suggest anything.
BTW, what you have done so far is not what I was suggesting.