help with query please read cant explain directly

[icemonster]

ok, the boxes on the picture should really explain my problem, i have the query, but when i put it in the list box, it shows the primary key not the text field.

anyone who could help is a blast

 

[DCrake]

It appears you are using table lookups in your table definition. This is not a good thing for all sorts of reasons. Simply change it to a FK type field and have another table with the choices in and createa relationship between them.

 

[icemonster]

can you elaborate please?

 

[icemonster]

what do you mean FK field? am really not getting it sorry. what i did was, in my tblA, i used another table for the value of that field in tblA. isnt that what you mean?