Could you create a POST Method Directive on Erp.PartTranHist on Method RunPartTranHistory with simply adding the EmpID as EntryPerson otherwise UserID?
I have also seen someone just hijack the PCID2 field which they have no intention to use PCID2 and just renaming the Grid Column.
var PartTranHistory =
(from ph in ttPartTranHist
join pt in Db.PartTran.With(LockHint.NoLock) on ph.TranNum equals pt.TranNum
select new { HistoryRow = ph, EmployeeID = pt.EmpID }
).ToList();
foreach (var row in PartTranHistory)
{
//row.HistoryRow.PCID2 = row.EmployeeID;
if (row.EmployeeID != string.Empty)
{
// Or even splitting it showing both on 1 column
row.HistoryRow.EntryPerson = string.Format("{0} / {1}", row.EmployeeID, row.HistoryRow.EntryPerson);
}
else
{
row.HistoryRow.EntryPerson = row.EmployeeID;
}
}
EDIT: Don’t join on the ttTable - this is an old Query. Just extract it out of there.