By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Automatically Updated/Populated Fields

P: 2
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?
Attached Files
File Type: xlsx RMA Template.xlsx (34.8 KB, 276 views)
Feb 26 '12 #1
Share this Question
Share on Google+
4 Replies


100+
P: 759
This can be easy done using VBA code.
Do you agree this solution ? (Have you basic knowledge how to design a procedure with VBA ? )
Feb 26 '12 #2

P: 2
I am not very programmer savy. Would need the code and instructions on how to enter that code.
Feb 26 '12 #3

100+
P: 759
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.
Feb 27 '12 #4

100+
P: 759
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.
Attached Files
File Type: zip RMA.zip (128.9 KB, 29 views)
Feb 27 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.