Hey guys, I have this requirement which I cant really wrap my head around.
When a replacement part is entered by a user(this is setup on product description), we should prompt the user for the original item or SKU. After the user enters the original item, it should lookup the primary pick location (which is a field in inventItemLocation table) for the sku and place that in a field called combinedLocation (its in a custom table) on this form.
A bit more detail; the primary pick location (wMSPickingLocation) is a field in inventItemLocation table and the combined location is on a custom table I created. The mod should take the data from PrimaryPickLocation and update it in the combinedLocation field on the sales form.
I have gotten to a point where, if the item is a replacement, it prompts the user for an original item, and when that is entered it gives this error; “The data source is not embedded within a (parent) data source.”
Any ideas on how to proceed?