Lookup between two lists formated line items
Hi guys, im trying to do this lookup.
I will start by stating the goal i want to achieve:
i have 2 lists formated line items in module 1: Product and Partner. In module 2 i have one list formated line item called "quantity".
in module 1 i have a line item named "auto" that should be auto filled according to user's selection on the list formated line item called "partner".
when the user select product 1 and partner 1 i want the line auto
to autofill according to values stored in "quantity" (module 2)
module 2 is dimensionned by the lists "Product" and "partner".
ive included a pic of what i want to achieve.
Thanks in advance for your support 🙂