Hi there,

Quick background: I've created a form, the user entires info, hits submit, the info is copied to another layout and the form is then cleared. I have been setting each individual field (because I don't know of an easier way) and then clearing each individual field. I have done this and it has worked until now. The only difference I can see is that I have to go to multiple layouts for this script... Can someone tell me what is wrong here? It works for the first layout but not the others.

For example:

Go to Layout ["ACOU" (Student Eval)]

Set Field [student Eval::ACOU_Material, Form::ACOU_Material]

Set Field [student Eval::ACOU_Knowledge, Form::ACOU_Knowledge]

Commit Records

Go to Layout ["APIX" (Student Eval)]

Set Field [student Eval::APIX_Material, Form::APIX_Material]

Set Field [student Eval::APIX_Knowledge, Form::APIX_Knowledge]

Edited October 14, 200520 yr by Guest

Can you tell us what exactly is going wrong?

Sorry, I guess that would help.

The fields outside of ACOU are not setting... they are remaining blank.

Well I found out the main problem, my form fields weren't global fields, however, my comment fields (which are text fields) do not work even when they are set to global fields...

If both layouts are based on the same TO (Student Eval), then you should not even need to go to the second layout.

Go to Layout ["ACOU" (Student Eval)]

Set Field [student Eval::ACOU_Material, Form::ACOU_Material]

Set Field [student Eval::ACOU_Knowledge, Form::ACOU_Knowledge]

Set Field [student Eval::APIX_Material, Form::APIX_Material]

Set Field [student Eval::APIX_Knowledge, Form::APIX_Knowledge]

Commit Records/Requests

should work fine.

If there are quite a few fields, I would probably link the tables via a temporary ID and use Lookups or auto-enter calculations to pull the data into the second table.