You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

VB Excel add-in - How to configure LOV based on parent?

Working on a VB for Excel workbook relating to Purchase Requisitions — a Form-over-Table with Purchase Requisitions over Lines.

I need two fields in the Table, Supplier (name) and Supplier Site (name). I need the user to select a Supplier by name then select one of the Supplier Sites associated with it. The URLfor the Suppliers LOV site is /fscmRestApi/resources/11.13.18.05/suppliersLOV/{SupplierId}/child/sitesLOV.

I'm running into trouble supplying SupplierId as a path parameter in order to get the related Supplier Site (name) values.

The LOV for Supplier (name) is set up and works as expected.

The LOV for Supplier Site

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!