Access 2016 - combo box

i have a Form and on it  there is a combo box field.  The Form's table is tblCredit card
The data is picked from another table named tblCard Types.  Card types are like  Visa, MC, Amex and this table has only 2 fields, the ID field which is numeric and the card type field which is text.  Thus the data would be
1   Visa
2    MC
3    Amex

When I select the data from the combo box it is saved into a field in the tblCreditcard.  Although in the combo box I only have the field the Card type, thus allowing me only to select one of the 3 data  as above, but when after selecting I look at the table tblCreditCard, the data is entered as eg ; 1 and not Visa
Looks like I am doing something wrong but I do not what it is, hope the experts can please advise me.  thank u
jegajothyretiredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
if you want to save the text value, set the bound column of the combo box to 2
Note: the field card type must be set to text and not number
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dale FyeCommented:
actually, this is not normally considered "wrong", this is the behavior most database professionals would expect.  This results in smaller database files as it takes less drive space to store the value (1) than it does to store the text (Visa).  When viewing your data, I would recommend you create a query that links these two tables based upon the CardType field; That would allow you to view the name of the card type while still only storing the numeric value.  This would look something like:

SELECT myTable.ID, myTable.OrderName, myTable.CardType, tblCreditCard.Description
FROM myTable LEFT JOIN tblCreditCard on myTable.CardType = tblCreditCard.CardType

Use of the "LEFT JOIN" in this query ensures that all records from "myTable" would show up in the query results even if they do not have a value stored in the CardType column of the table.

HTH
Dale
0
jegajothyretiredAuthor Commented:
I like Rey's solution, as in one stroke, it solved the issue.  Thank u
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.