How To Bring Selected Data Back from a Layout

customaware

So, here is the scenario....

On a BO (let's call it Parent) Form I have a Reference Table of Owned Children (Child)
I execute an Add New Reference on the Children Reference Table. This opens in a Pop-Up

The Child BO (let's call it Child)has a ps_Product (Peer Single Reference of Product)
Under trivial circumstances that would be a Dropdown and the User would select a product and all would be good.

However, Product contains over 1,000,000 records and the user wants to be able to search them by Product Category and Product Supplier very quickly.

So, the plan was.... Create a Layout with a Category Dropdown (1,000 Categories) and a Supplier Dropdown (1,000 Suppliers) and then show a filtered Query below that panel.
It looks like this...

So this part in itself works great.
The User selects a Category from the Category Combo and the Query below only shows records of that Category. Also the Supplier Combo is filtered to only show the Suppliers that have products in the filtered Query.
They then select a Supplier from the Combo and the Query is filtered down even further...

OK. Crunch time....

Parked on the Add Reference Child Form....
Next to the Product Dropdown we place a Search button. This button runs a process (passing Child) which clears the Category and Supplier references in LIRU and then displays the Layout.

LoggedInRegularUser.ps_SelectedCategory = UNDEFINED
LoggedInRegularUser.ps_SelectedSupplier = UNDEFINED
DISPLAY LAYOUT 'Product Search' FROM_VP Layouts

The 'Product Search' Layout is now displayed.

The User Filters and then chooses a Product by Clicking the Select Button to the right on the row.

Question is... How to get that selected Product back into the Child Form that is still open underneath the Layout?

I have spent the last 24 hours practicing for the Olympic Gymnastics team trying to work this out to no avail.

tford

This button runs a process (passing Child) which clears the Category and Supplier references in LIRU and then displays the Layout.

Question is... How to get that selected Product back into the Child Form that is still open underneath the Layout?

So you passed the Child to the Product selection process, but are having a problem showing the product on the Child Form ... is your Product Selection process able to update the Child's Product properly & just not able to display it?

customaware

The Process that calls the DISPLAY Layout has the Child in context.

Let's call this Process A

Once the Layout is displayed on the screen it is not trying to display any data from the Child.
All I have is 2 Combo's (one displaying LIRU.ps_Categories and one displaying LIRU.ps_Suppliers) and a Query of Products.
Ok. User clicks Select on a Product. So to capture which Product was selected I call another Process B .... LIRU.ps_SelectedProduct=Product

The user then Closes the Layout with a close button and we now back looking at the Child Form which still has the empty ps_Product combo on the form. This is the attribute I want the selected product stuffed into.

Process A is gone and no way to get back to that.
Process B has no knowledge of the Child instance (I did try passing child here as an input but it is not found)

tford

Would this work?

1) In Process A, store Child in LIRU.Selected_Child
2) In Process B:

Find the Child using LIRU.Selected_Child
Child.ps_Product=Product

3) In the Form in the layout, have Process B in AutoRefresh

customaware

I have already tried precisely that Tom and no go.

tford

Which part doesn't work?

tford

Does it get stored in the child record and not displayed?

customaware

I will check Tom....

Can't right at the moment.... Will let you know...

You should be asleep. 😉

Jaymer

dont execute the built-in ADD REFERENCE

make a button 'Add Child' which starts your search/filter process.
after the final record is selected, you just have to

CREATE NEW child WITH
ps_product = LIRU.selected_product
child.ob_parent = ParentObject

INSERT child IN ParentObject.om_child

then a redraw and the child should appear

customaware

Thanx Jaymer....

Nice idea and I think would be fine if they had to pick a product and NOT change their mind.
Problem is... that once they select a product and are sitting at the Child Form..... if they then change their mind and want to select a different product, then we are back to the same problem
as before.