using pulldown for field population

[nolanbeatty1]

I'm switching from MS Access to using Base.

When creating a table in Access, I was able to create a field whose content could be populated from another table. For example, I had a field called "name" that is populated by using a pulldown menu containing existing names from another table. So when I was using a form to keeping track of expenses, for example, I didn't have to enter a person's name in the name field - instead I could just use the pulldown to select the name derived from another table. That way, all the names would be spelled consistently for when I pulled reports.

I'm sure Base will allow me to do this, and I've been trying to figure out how to do it, but I just can't seem to figure it out. Suggestions and guidance will be appreciated from those who can show me how I can accomplish this.