I have UD columns for OrderNum and OrderLine on the JobHead table. I want to add a FKV to the Sales Order tracker so I can pull in the job data. We link some maintenance jobs to sales orders with these UD columns which may or may not be a good idea. In any case we have that and I am trying to add a FKV to the jobhead table in the Sales Order tracker bases on these UD columns.
I can see how to add FKV when the link is on the parent table (ie if I had the Jobnum in the OrderDtl table) but what about when the link is on the child table?
I can achieve my end result with a BAQ/dashboard and pull that into the screen however I want to extend my knowledge here so I am putting this out there to see if anyone knows if it is possible.
Not sure but you can try to add the original field LIKE data to the custom fields in JobHead and see if that will get you there. My example is OrderHed so you will need to change that to OrderDtl but you get the idea.
If that doesn’t do it, a BAQDataView will do it for you.
So it looks like this is not possible with a FKV. Seems you need the key to the child view in the parent view as opposed to the other way round. I have solved my goal with a BAQDataview.
Note: the default job link in Sales Order Tracker shows manufacturing jobs for the Sales Orders. We have a custom made link to maintenance jobs and that is what I am trying to show.
