Jump to content

Can't modify record through window?


abomb
 Share

This topic is 5677 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5677 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.