crobaseball
Board Regular
- Joined
- Mar 14, 2014
- Messages
- 59
Hello,
I'm a novice and nouveau user of Access 2010. I have the concept of Lookups down. What I'm trying to figure out is how to use the lookup to pull info by my primary key, but display different descriptive info.
I have a field which selects colors using a lookup to a diff table. I want to denote each color with a primary key which will always be unique, but then see the actual name of the color. I'll eventually use a query to pull the info in.
Thank you!
I'm a novice and nouveau user of Access 2010. I have the concept of Lookups down. What I'm trying to figure out is how to use the lookup to pull info by my primary key, but display different descriptive info.
I have a field which selects colors using a lookup to a diff table. I want to denote each color with a primary key which will always be unique, but then see the actual name of the color. I'll eventually use a query to pull the info in.
Thank you!