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 firstname.lastname@example.org 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.