Set Field and Insert Calculated field errors

[slylock_fox]

I am brand new to this forum and fairly new to the use of FileMaker Pro. I am currently using FMP 10 and am having some problems with cross table functions.

I am trying to create a script that will essentially allow me to copy fields from layout A, hold onto those fields, then copy fields from layout B onto layout A, then paste the fields from layout A to layout B. Basically just switch the fields from layout A to layout B and from layout B to layout A.

Sorry if this seems confusing. What I am doing right now is I have all of the layouts on one table my Equipment table, and then I have a Swap_HD's table to hold onto the data in transit. However, where my problem occurs is when I try to use the set field function in my script to automate this process, it doesn't copy from my Equipment table to my Swap_HD's table...Any ideas?

Thanks,

The Fox

[comment]

Your question is not entirely clear. Copying fields from one layout to another is done in Layout mode, and cannot be scripted.

[backsmith]

Hi

Can you explain a bitmore what your data relates to. I cant follow why you need to move the fields from one layout to another.

Are you for example copying data from one record to another in the same field in the same table, or from one field to another in the same table, or a field from one table into a field from another.

[slylock_fox]

Sorry for not being very clear. The data has to do with equipment that we use in our building. So whenever we have a computer that comes into us and we swap the hard drives from one computer (one record in the equipment table) to another computer (another record in the equipment table), we want a script that will circumvent having to copy and paste each value from each field from one record to the other. And the only way we can figure that we do this is to copy the information onto a seperate table, a holding table, then copy the fields from record B over to A, then from the holding table, paste the fields from the holding table to record B.

Essentially, its not really pasting from one layout to another, I'm trying to get the information in one record and copy it over to another record on a separate table.

[comment]

I am not sure how you handle this in terms of user interface (since you need to select two records), but you certainly don't need a "holding table" - use script variables to hold any temp data, and use Set Field instead of Copy/Paste.