Lookup and relationship problem
I've spent all afternoon trying to get lookups to work, without success. I want to create receipts for orders that are being fulfilled. The open order line items from the order need to be displayed in the receipt portal, so that I can change the quantities in the receipt if there is a discrepancy between the quantity ordered and the actual received quantity. The quantity in the order should not get updated when I change the quantity in the line item of the receipt. This is what I cannot get to work. Whenever I change the receipt the order changes also. I have tried I don't know how many different relationships between the tables… but nothing seems to get it right. See the attached image.. Thanks.