Form, Combo box value display

[Chair]

Hello, is it possible to display a related value from another table in combo box, instead of actual value?


For example, if I have a database with artists and albums, albums are connected with artists only by the foreign key artistId, and in my form for adding albums I want the combo box with album artist to display the artist name instead of artistId, what should I do? I figure it should be some very basic function, but the only solution I've come up with is making a query and a combo box based on it, I can't make it work though.

[orange]

Lot's of combo box info at techonthenet. Here is a link

Good luck.

[Chair]

Thanks, I've just found the answer! It was a really basic function indeed, the list of values displayed and the field connected with selected value are separate things as I'd figured they should be, the list called row source if anyone else wants to know. Topic closed.