With PB 12.5 here.
I have a datawindow called d_locationpath, which is to query and combine parent and child location to get the location path (full directory), as below.
Fyi, I can't get this Location Path directly from database and that's why I create this datawindow to get it.
My question, how to link another datawindow to this d_locationpath datawindow to get Location Path based on Locationid?
d_stockitem has locationid and I would like to use this locationid to get Location Path in d_locationpath (where d_stockitem.locationid = d_locationpath.locationid).
Thank you in advance.