Hello, i'm trying to make a form in which one field is automatically populated from the selection in a combo box (which pulls from a table)
Bascially i have a list of unique entity numbers and unique entity names. What i want to have happen is i select the entity number from the list and the other field automatially pulls the corresponding name (which is right next to it in the table)
I created a formula which replaced the control field but of course, although it populates it on the form, it does not save it within the table as the contol source is now replaced.
Is there a way to do this so that i it will save the corresponding value in the table?
Thanks
Bascially i have a list of unique entity numbers and unique entity names. What i want to have happen is i select the entity number from the list and the other field automatially pulls the corresponding name (which is right next to it in the table)
I created a formula which replaced the control field but of course, although it populates it on the form, it does not save it within the table as the contol source is now replaced.
Is there a way to do this so that i it will save the corresponding value in the table?
Thanks