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

[Chandeep]

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

[NeoPa]

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.

[Chandeep]

Thank you soooooooo much

You have no idea how happy that has made me

Cheers

Chandeep

[NeoPa]

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.