I have two tables: for sake of ease lets call them Table A and Table B residing in a single file.

In table A I have a field called "Design_Number". In table B I also have a field called "Design_Number". I would like to write a srcipt that when called freezes the window in table A, creates a new record in table B, then sets the data A:design_Number into b:design_number.

Currently my script looks like this but it does not work, can anyone please help?

Freeze Window

Goto Layout ["DataEntry" (TableB)]

New Record/Request

Goto Layout ["HomePage" (tableA)]

Set Field [TableB::Design_Number ; TableA::Design_Number]

Any help would be appreciated. Set field always gives me trouble. it seems like it should be so straight forward but it always challenges me.

Thanks in advance for any help,

Steve Freeman

Freeze Window

Goto Layout ["HomePage" (TableA)]

Set variable[$Design_Number;TableA::Design_Number]

Goto Layout ["DataEntry" (TableB)]

New Record/Request

Set Field [TableB::Design_Number; $Design_Number]

Goto Layout ["HomePage" (TableA)]