Instead of Go to Layout ["data entry"]
change it to Go To layout ["picacontax" (picacontax)]
Then new record should create a new record in the picacontax table of the other file. (Open File should not be needed, it should open automatically when you switch to the picacontax table.
Thanks again Phil
but newbie question now - how do you Specify Layout Name by Calculation using syntax ["picacontax" (picacontax)]?
doesn't like it, and Go To Layout ["picacontax"] alone doesn't work...and there isn't a Layout named 'picacontax'...
and there isn't a Layout named 'picacontax'
And that's your problem here. Create a layout named picacontax based on the picacontax table occurrence. (You can name this layout anything you want, I used the same layout name as the table occurrence for simplicity.) If you already have created a layout that is based on picacontax, you can use go to layout to select that layout and your script will work.
You need this layout to establish "table context" in your script so that new record can create a new record in the appropriate table.
Of course! I just hadn't realised that of course you can make a layout based on an external table..like I said - totally newbie question
thanks once again Phil