AnsweredAssumed Answered

Calculated field to show results from another table

Question asked by guyscharf on Dec 19, 2017
Latest reply on Dec 19, 2017 by philmodjunk

I have two databases, call them A and FE.  A has three email address fields email1, email2, email3.  FE is a table of email addresses and a data field.  Email1, email2, and email3 are all linked to FE.  What I want to do is add calculated fields to A, call them FE1, FE2, and FE3, whose contents will be calculated to indicate whether email1, 2, or 3 whose contents are the data field from FE for that email address.


For example, if FE has an email1 entry of with data numeric 2, then I would want FE1 to be 2.  If FE didn't have that email entry, then I would want FE1 to be 0.


I'm sure I'm missing something simple, but it's been a while since I've worked on this application and the solution is escaping me.