Hi - this sounds like it should be simple but I can't make it work:
I have 2 tables, joined in a query to populate a form.
TblPOI has Userid, POINAME, EMAIL (e.g. JMS, John, myemailaddress)
tblINCIDENTS has among other fields POI, IC (POI links to UserID). I want IC to update to POINAME when I...