Go to layout, set field...

[Calantha]

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, 2005 by Guest

[Zero Tolerence]

Can you tell us what exactly is going wrong?

[Calantha]

Sorry, I guess that would help.

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

[Calantha]

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...

[-Queue-]

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.