AnsweredAssumed Answered

Lookup and Calc?

Question asked by ponderosa on Apr 30, 2018
Latest reply on Apr 30, 2018 by ponderosa

Is there a way to do a look up and some kind of calc or something in the same field? I have a field - NumberOfCases - that looks up into a different table - CasesInfo - to determine what to put in the field. Now, my client also wants it so that if a different field in the same table as NumberOfCases (table being named Work Order, field being Type) has a certain entry, NumberOfCases is always 1.

I'm thinking that this is impossible, but thought I'd check. Thoughts...