Hella all,

I'm new to this forum :) so I say hello to all of you :)

I have a little problem..

I have a table wich stores information wich comes from a combobox.
The problem is that it saves the combobox ID instead of the text.

This is the row source of the combobox

SELECT rapporteur.ID, rapporteur.rapporteur FROM rapporteur;

Could somebody tell me how I can store the rapporteur.rapporteur in a other table instead of the rapporteur.ID?

thx a ton in advance

It's doing what its suppose to do, its not a good idea to store the actual text unless you have a specific reason...

well.. when I make a report, it shows the ID's instead of the text, for me it's clear what every ID is, but other people also have to understand the report. Is there a way to alter this so it shows the text in a report?

Use a query which includes both tables, you can then return the text instead of the ID, base the Report on the query

well, i figured out an other way.. I simply changed te primary key to the text field, I don't use relations so no woory's there :)

well, i figured out an other way.. I simply changed te primary key to the text field, I don't use relations so no woory's there

You'll curse yourself sooner or later on this "solution" :D

RV

well, i figured out an other way.. I simply changed te primary key to the text field, I don't use relations so no woory's there :)

Listen to the replies that you've had and stop wandering off into making errors that you don't know you're making.Revert to the Autonumber field as Primary Key and, use a query to join the two tables. Select the fields from both tables you need in this query. Bind the query to the form and not a table.

ok, I did it your way. thanks for your input :)