Automatically Updated/Populated Fields

[Sean Unrau]

I have a database that I have a user enter "Unit" type information (drop down menu). I need to have 2 other fields - "SKU" & "Unit to Ship" - automatically enter data based on what the user has entered in "Unit":

User Enters - K1 Black in "Unit"

Database enters automatically - N416-KBO-B in "SKU" & RG-N416-B in "Unit to Ship"

All the "SKU" & "Unit to Ship" are in one table.

All the remaining data is stored on a Main Table.

How would I create the Main Table to do this?

[Mihail]

This can be easy done using VBA code.
Do you agree this solution ? (Have you basic knowledge how to design a procedure with VBA ? )

[Sean Unrau]

I am not very programmer savy. Would need the code and instructions on how to enter that code.

[Mihail]

Oh,
SORRY for that. Really sorry.

I see your .xlsx file and I think that it is a Excel problem.
Now, when I start to design the VBA code I see that your problem is solved in Excel (by using VLOOKUP function) and I realized you need to do the same thing in Access database.

But databases do not work the same.
In databases is no need (more than, is a big mistake) to store data in more than one place.
Take a look here to understand why:
http://bytes.com/topic/access/insigh...ble-structures

Until you read this I'll try to sketch a very simple database for you in order to use it as a start point.

Again, really sorry for my mistake.
We'll "see" soon.

[Mihail]

You have a sketch for your database.
Of course is not fully functional.

If that don't help you, show us what you have done until now as ACCESS database.