Can't modify record through window?

[abomb]

Hope this is the right place for this one.

I have 2 tables; Inventory and Receivable. On receivable Layout I have a portal to allow entry of about 5 fields. Then the dimensions of the item need to be entered. We are a job shop, and items received need different inputs for the dimensions. A round bar only needs 2 dimensions where a plate needs 3. To make the process of entry easier for my users, have a field in portal to select Invetory Type, push a button that opens a window to enter dimensions only then just close the window. All possible dimensions have fields on the Master Inventory record.

When I try to enter data in the fields on the window, I get error message "this record cannot be modified in this window because it is already being modified in a different window." I kind of understand the problem but is there a way around this? I need one record for each item no matter if it is a plate or an angle. The strage thing is that if I close the window, move to another layout and try it again, it lets me enter the fields. It just won't let me do it all in one step.

[John Mark Osborne]

Try the Commit Records/Requests script step. I don't know what your script looks like so I can't tell you where to put the step but it should solve your issue of trying to modify a record through a portal and in another window at the same time. Essentially, it just exits all the fields on the record, including the portal.

[abomb]

I did try the commit record in the script but couldn't get it to then find the right record.

Here's the script

If[inventory::Stock Type="Plate"]

Go to Related record [show only related records; Match found set; From table:"Inventory";Using layout:"Plate Entry"(Inventory);New window]

Go to field[inventory::Thick]

Else IF

...

...

End if

I didn't write the "whole" script but the rest of it just repeats with different If calc.

Maybe a little more info. The Receipt window has another portal linked to a PO table. This way, Receiving dept can see if all the items have been entered. Could be many items being received at one time. When I put in the Commit Record; when I would try to go and enter a new item, in the window, it would bring up the first record, not the related record. Maybe I was just putting the script step in the wrong place? Any help would be great.

[comment]

Yes, the side-effect of Commit Records[] is that you are no longer in the portal. Therefore, GTRR goes to the FIRST related record.

See here for a solution.

Note that having another portal on the layout requires you to make sure that the 'correct' portal is layered more backward on the layout than the other portal. Otherwise Go to Portal Row[] will go to the other portal.