Newbie here and trying to understand the auto-enter function of a field. I'm missing something (I know) because it's not working. Is it a relationship between two fields that I need? I've even tried to use a calculation for this and it won't work either.
Basically, if I want the name of a contact to be looked-up and automatically put in once the customer number is entered, what's missing? I've even tried using a calculation for this and can't get it to work either. Do I need a relationship between the name fields and the customer number, even though they are in the same table? Any help would be appreciated.