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

putting product id code

P: n/a
I sometimes have to do a lot of putting product id codes for very large
tables of products in Access.

Unfortunately, it's not a straightforward two-column lookup table as
there are three components that make up a product id code: productname,
size and color.

For example,

productidcode productname size color
7223 golfballs medium white
7994 socks small black
8773 shirts small blue

If I have a table with all the field info except the productidcode, how
would be the easiest and most efficient way to code these very large
tables quickly?

Is there a way to use the lookup feature for this?

Thanks.

Matthew Kramer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Presumably you do have a lookup table, which shows the correct ProductID for
each combination of productname, size, and color?
In normal Access usage, you would not add the ProductID into your large
table directly.
When you want the information from your large table and the ProductID at the
same time, use a query, with joins on the 3 lookup fields.

HTH
- Turtle
"Matthew Kramer" <mk********@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .
I sometimes have to do a lot of putting product id codes for very large
tables of products in Access.

Unfortunately, it's not a straightforward two-column lookup table as
there are three components that make up a product id code: productname,
size and color.

For example,

productidcode productname size color
7223 golfballs medium white
7994 socks small black
8773 shirts small blue

If I have a table with all the field info except the productidcode, how
would be the easiest and most efficient way to code these very large
tables quickly?

Is there a way to use the lookup feature for this?

Thanks.

Matthew Kramer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #2

P: n/a
You can also you a single number (autonumber) field to be your primary key
and place the productname, size and color as 1 key in the index and assign
it to Unique so it cannot be duplicated. Then you can link your primary key
(one field) to any table you want.

I have done this many times with great success.

HTH
Paul

"Matthew Kramer" <mk********@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .
I sometimes have to do a lot of putting product id codes for very large
tables of products in Access.

Unfortunately, it's not a straightforward two-column lookup table as
there are three components that make up a product id code: productname,
size and color.

For example,

productidcode productname size color
7223 golfballs medium white
7994 socks small black
8773 shirts small blue

If I have a table with all the field info except the productidcode, how
would be the easiest and most efficient way to code these very large
tables quickly?

Is there a way to use the lookup feature for this?

Thanks.

Matthew Kramer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #3

P: n/a
Thanks for the explanations. I will try them. - Matthew

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.