I have a field called gate code on my contact record. I have gate code set as a lookup field in another table for service calls. It works great until someone wants to enter a new gate code from the service record. I think I need to add a second gate code field to the service call record and then make then send that to the contact record as a lookup field. then I can create a form rule to show either or both if they are not blank? Will this even work? Am I thinking too much? Is there an easier way?