This is probably a basic question for of you but here goes.
I have a number of tables in my database, and they're linked in with a form. I'd like to have a field in a form that's populated automatically based on what's inputted in a different field.
For example, I've got one table with names...