AnsweredAssumed Answered

Problem creating multiple records in Table B from Table A

Question asked by jgm_1 on Jul 19, 2011
Latest reply on Jul 28, 2011 by philmodjunk

Title

Problem creating multiple records in Table B from Table A

Post

I am trying to generate multiple records in a table from a related table. The tables are related by TableA::tablebID which is just a numeric field to TableB::tablebID which is an Auto-enter Serial, Unique numeric.

In table A I have a button which runs the following script:

Perform Script ["New Record" from file: "TableB"]

Set Variable [$var1; Value:TableA::Var1]

Go to Layout ["TableB::Layout 2"]

Set Field [TableB::Var1; $var1]

Set Variable [$var2; Value:TableA::Var2]

Go to Layout ["TableB::Layout 2"]

Set Field [TableB::Var2; $var2]

In table B the script "New Record" is:

New Record/Request

My problem is that I can only ever seem to get the variables into TableB once.

Outcomes