Awesome, that works great. However, I did run into a problem. In my Name Table, with Name_Id and Name field, some IDs have the same Name. So when I try to choose them in the lookup field, I can only select the first ID. What's a fix?
Thanks!
I have a form where I have a lookup field. It comes from a table with two fields, Name_ID and Name. The lookup is set to show me the name ID. How can I get the Name to be displayed on the table though? Thanks!