OliverWilton
Registered User.
- Local time
- Today, 01:43
- Joined
- Nov 25, 2008
- Messages
- 15
I'm currently on work placement and am building a setting up product database. I have a desire that has been given to me but i'm not sure if it's feasibile but i'm convinced it must be.
Basically there are fields such as Planners, Buyers, Class Codes, etc and they are linked to their own Planner/Buyer/Class Code tables, the values are then stored in the main product table.
The staff currently use IDs/Codes for inputting. So i want to know if it's possible for them to type in the ID in either a combo box or text box, but after entering the code.. the name appears, rather than the ID.
Also i'd want the name/description rather than the ID/Code to be displayed on the form rather than the ID.
Any help appreciated. Thanks!
Basically there are fields such as Planners, Buyers, Class Codes, etc and they are linked to their own Planner/Buyer/Class Code tables, the values are then stored in the main product table.
The staff currently use IDs/Codes for inputting. So i want to know if it's possible for them to type in the ID in either a combo box or text box, but after entering the code.. the name appears, rather than the ID.
Also i'd want the name/description rather than the ID/Code to be displayed on the form rather than the ID.
Any help appreciated. Thanks!