Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-19-2019, 06:37 AM   #1
awaldrep
Newly Registered User
 
Join Date: Sep 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
awaldrep is on a distinguished road
Table is recieving ID instead of description from form

I have a form with two combo boxes where one is dependent on the other. Essentially the user will select a category of products in the first one, and a specific product in the other. Once the record is saved it puts that data in the table associated with the form. However it shows the ID for both of these fields, instead of the description of it. I.E. it will show a 1 vs. the specific product name. The number won't mean much to those using it so I would like to have it where the names are what's going into the table fields. Is there a way to do this?

Thanks!!

awaldrep is offline   Reply With Quote
Old 09-19-2019, 06:58 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Table is recieving ID instead of description from form

actually that is the correct way, to save to id of the number and Link it back to the table (via query) to get the description. otherwise, you are only duplicating what is already on the other table.

but it is your call, on design view of the your form, set the Bound Column of the combo to 2.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-19-2019, 07:11 AM   #3
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,389
Thanks: 434
Thanked 804 Times in 779 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Table is recieving ID instead of description from form

I would not do it. If that descriptive name changes for any reason, you will lose relationships.

Just retrieve the descriptive name when needed. It is very easy to do.

Plus users should not be looking directly at tables, only at data through forms/reports and perhaps queries.

Quote:
Originally Posted by awaldrep View Post
I have a form with two combo boxes where one is dependent on the other. Essentially the user will select a category of products in the first one, and a specific product in the other. Once the record is saved it puts that data in the table associated with the form. However it shows the ID for both of these fields, instead of the description of it. I.E. it will show a 1 vs. the specific product name. The number won't mean much to those using it so I would like to have it where the names are what's going into the table fields. Is there a way to do this?

Thanks!!

__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Old 09-19-2019, 03:35 PM   #4
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,271
Thanks: 15
Thanked 1,593 Times in 1,513 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Table is recieving ID instead of description from form

Users NEVER, EVER get to look at raw tables or queries. users only interact with forms and reports you create for them. You use queries (or combos), as the others have suggested to display the data.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Tags
dynamic combo box , form , table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form labels - possible to take from table field description? HGCanada Forms 4 01-25-2018 02:40 AM
Table not recieving data KevinRDougherty Tables 1 04-19-2011 12:59 PM
Table Description edwarric1 Modules & VBA 4 02-20-2009 05:58 AM
Table description KenHigg Modules & VBA 34 06-05-2008 09:00 AM
Field Description per Table Randomblink Tables 3 06-18-2002 04:31 PM




All times are GMT -8. The time now is 09:15 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World