When I select a line in my process screen, the selected line is updated but its values get replaced with data from the first RQRequisitionLine.
I know this happens because RQRequisition only has ReqNbr as a key, but not LineNbr. Unfortunately, I cannot add LineNbr as a key in my projection.
How can I make the grid work so that when I check Selected, only the Selected field changes, and the rest of the data for that row does not get overwritten from the first line RQRequisitionLine?
[Serializable]
[PXCacheName(Messages.RQRequisitionLineOwned)]
[PX.TM.OwnedEscalatedFilter.Projection(typeof(RQRequisitionLineSelection), typeof(RQRequisition),
typeof(LeftJoin<RQRequisitionLine, On<RQRequisitionLine.reqNbr, Equal<RQRequisition.reqNbr>>>),
null, typeof(RQRequisition.workgroupID), typeof(RQRequisition.ownerID), typeof(RQRequisition.orderDate))]
public class RQRequisitionLineOwned : RQRequisition
my virtual Dac is Projection.
I can’t set key value to RQRequisition.reqNbr and RQRequisitionLine.lineNbr because i must view records with RQRequisitionLine and without. Help me please