ID in Table when selecting Text from dropdown-menu

Diversion

Dutch Databaser
Local time
Today, 22:22
Joined
Apr 13, 2005
Messages
16
Here's my problem:

I got a Table which contains software:

TblSoft:

ID |Software
-------------
1 |Office
2 |Winzip
3 |Etc.

I made a form with a dropdown-menu in which I can select the software and it stores it in another Table named TblPC.
It stores something allright. but not the text. It stores the ID Nr.
How do I get this to work that it puts the text inside the table instead off te ID nr?

I allready tried changing the properties off the listbox but it wouldn't help.
 
Last edited:
Storing the ID number is correct. Although I'd rename the field SoftwareID.

Since the ID is a number it takes up less space than a text string and, when you join the two ID fields in a query you can then select the Software name into the query.
 
Didn't think off Queries before.

Thnx for the quick help!
 

Users who are viewing this thread

Back
Top Bottom