Is it possible to use the Context.AssemblySeq to indirectly look up the JobAsmbl.PartNum to load this to an Inspection Plan Form control in the “On Load” Event expression? I am new at this and don’t find in my searches any examples of how to use these:
The other thought I had was could we increase the fields that are supplied with the Context data to include this field we need? I was not sure if this Context list was dynamic or fixed.
I broke that up into multiple lines for readability. Normally it’s just one long expression.
That will search the JobAsmbl table for the first record that matches all the conditions in the .Where() part. You can add more conditions. And you’ll need to replace MyCompany, JobToFind, and Seq.
If a record is found, it sets the variable pn to the value of the PartNum field.
If no matching records are found, it sets pn to "NotFound"
Other than what I inserted with the Context fields, if that is even correct, do i assign pn to a control with a
Inputs.epiPcTextBox1.Value = pn; statement ?
I am guessing I need to change the Db to my database name like “Epicor10” if that is the database I connect to in SSMS?
As you probably know this inspection plan is being called from the Inspection Data button. This field on this End Labor Activity display is not passed along in the Context list. Can you tell me how to reference it? Is there any way to add to the available fields in the Context list? See second image.