Is it possible to take fields from a database and create a pulldown with those fields concatenated?

[cherold]

I know what I want to happen, but I don't know if it's possible.

I'm creating a database for my album collection. The main table will be called Albums. There will also be a Performers database (first name, last name, band name).

For an example name, let's say Petty, Tom, Heartbreakers.

I know I can take that information in a report and display it as I like with the right formula, such as "Tom Petty, Heartbreakers," or "Petty, Tom - Heartbreakers." But I'm wondering if I could use a formula to populate a pulldown menu.

What I would have done in the past is have a performer_id field in Albums and use a combo box to display the names (which would just look like Petty Tom Heartbreakers). But instead, I'd like to format the information from the table so that I have a pulldown menu that just displays an alphabetized list of name strings. So the pulldown could look like:

Jett, Joan - Blackhearts
Petty, Tom - Heartbreakers
Queen
Joplin, Janis

If this much is possible, then there's the matter of selecting an item, since it's going to be a long list. Ideally I would be able to start typing "Petty" and jump down to the proper name, or at least tap "p" and have it go to the Ps.

Can some or all of this be done? Thanks for your help. I hope my question is clear.

[Perceptus]

I would create a query that concatenates the fields like you want to see. like

Select dbo.tblAlbum.ID, dbo.tblAlbum.artistname & space$(1) & dbo.tblAlbum.name from tblAlbum

then use that query to populate a dropdown

[June7]

Certainly.

Combobox RowSource could be like:

SELECT ID, LastName & ", " & FirstName & " - " & BandName AS Performer FROM Albums ORDER BY LastName;

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.