Hello everyone,
I am a novice Access user. Our company is moving a lot of these logs from Excel to Access and I have been learning Access on the fly.
Just to give you an idea of my skill level, I have gotten the hang of things as far as creating tables, forms, and split databases, and I just google my questions when I get stuck and often end up on this forum. I have yet to find step-by-step instructions on how to perform this "auto-fill" function so your assistance will be greatly appreciated.
Just as a side-note, I am using Access 2010:
One of our logs includes the following 4 fields:
SE (sales executive) | Region | Tier | Sales Channel
We want to make it so that the "Region", "Tier", and "Sales Channel" fields fill out automatically depending on which "SE" was selected.
So if I select "Ron Burgundy" from the "SE" field,
"Region" should auto-fill: West
"Tier" should auto-fill: 2
Sales Channel: Inside
If I select "Marco Polo" from the SE" field,
"Region" should auto-fill: East
"Tier" should auto-fill: 2
Sales Channel: Outside
And so on.... I am working with only one table, but I am willing to create another table if this action requires multiple tables.
Please let me know how I can make my request more clear. I am not sure if I am asking this in the right section either.
Thank you so much!