423,504 Members | 1,140 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,504 IT Pros & Developers. It's quick & easy.

Combo Box: Select one field, but store another related field

P: 2
Hello to all friendly helpful access experts,

I have used Access many times in the past but this problem has always stumped me. I am currently developing a database and am almost certain that it is normalised as I have used numbers instead of long text wherever possible to prevent data duplication. The main problem with is with data entry as the users of this database do not want to be entering

PROBLEM: My form is for data entry purposes, based on a table "Registration". The problem is that the user does not wish to enter into the Combo Box the Club ID (number)

How do I have the combo box select the Club Name, but enter the number of that Club ID into the Registration table (Club ID) ?

*Registration table*
Registration ID
Name ID
Club ID
Month ID

*Club table*
Club ID
Club Name

Any assistance would be much appreciated as this has been bugging me for years :)

Chandeep
Nov 1 '06 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,046
If you use a ComboBox set it up as follows :-
Row Source Type = Table/Query
Row Source = *Club Table* (whatever the correct name is)
Column Count = 2
Column Widths = 0cm;{n}cm (where n is width of ComboBox)
Bound Column = 1
List Rows = 8 (or whatever you have space for)
Limit to List = Yes

Whenever you then refer to the ComboBox, it will return the selected ID, even though the operator is selecting from a list of names.
Nov 1 '06 #2

P: 2
Thank you soooooooo much

You have no idea how happy that has made me

Cheers

Chandeep
Nov 1 '06 #3

NeoPa
Expert Mod 15k+
P: 31,046
Thank you soooooooo much

You have no idea how happy that has made me

Cheers

Chandeep
Oh yes I do - I've been there.
I presume from your response that you've tested all ok?

-Adrian.

PS It was made MUCH easier because you laid out the question clearly and fully.
Nov 1 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.