I'm a bit confused by this information:
Layout using the (PurchaseOrder) table w/ portal rows using Related (PurchaseOrder PurchaseOrder_Status Open) So it list all open Purchase orders.
it is suppose to load the information on the line item Portal row (PurchaseOrderLine) to (RECEIVING
From your screen shots, it looks like you have a portal to PurchaseOrderLine, not Purchase orders
In any case, the basic method is the same:
Set Variable[$PurchaseOrder ; Value: PurchaseOrderLine::PurchaseOrderNumb ]
Set Variable [$OrderLine ; Value: LineItemNumb ]
Go To Layout [//Select Layout for receiving]
Set Field [Receiving::PurchaseOrderNumb ; $PurchaseOrder]
Set Field [Receiving::LineItemNumb ; $OrderLine]
To move more data, use more variables, or, if you have the right relationship, the other fields can be set to copy the data via Looked up value settings once you've used set Field to assign the value to the relatioship's key field.
Still having trouble getting the solution you gave me to work. I guess I have a relationship problem...
Feel free to describe the ways in which it is not working.
I gave an example script that you would have to modify to match the actual design of your database by selecting fields and table occurrences that actually exist in your system. Thus, having some trouble with it isn't too suprising here.
Again thak you for your help..
PurchaseOrderLine – table
PurchaseOrderLineSeqNo – Item Line number
RefNumber – Purchase Order number
From the PurchaseOrderLine table - I need to launch a popup layout with these two fields populated
Inventory_In – table
Create New Record
Load, PurchaseOrderLineSeqNo and RefNumber
This will allow me to get the other fields I need to load in the Inventory_In table
it seems so simple, but for some reason I can't get it to do that.
Set Variable[$PurchaseOrder ; Value: PurchaseOrderLine::RefNumber ]
Set Variable [$OrderLine ; Value: PurchaseOrderLine::PurchaseOrderLineSeqNo ]
New window [//specify name, location and size of window]
Go To Layout [Inventory_In]
Set Field [Inventory_In::RefNumber ; $PurchaseOrder]
Set Field [Inventory_In::PurchaseOrderLineSeqNo; $OrderLine]
There are additional steps you can include to hold this new window in front and not allow the user to interact with any other windows until this window is closed.
can you explain the steps how you selected the Set Field? Having problem to locate the $PurchaseOrder