Join Query from one Table?

[poporacer]

I have a table that has two fields for similiar information.

tblName
ID
Name
Nickname1
Nickname2
Nickname3
I have a form that I want to search for someone by nickname... on the form I have a text box for the user to input the search criteria. There is a Listbox that I need to populate with a list of the AKA's (there could be some names that have more than one nickname and some that have none... I don't want the list to include Null entries for the nickname). Hopefully this explains what I am trying to accomplish. If I can figure out the query to populate the listbox, I have the rest figured out.

tblName

ID Name Nickname1 Nickname2 Nickname3
1 Paul Smarty Einstien
2 John
3 Sally Silly Smarty BoMally
4 Kim Girl

Form

Listbox (query results)

BoMally Sally
Einstien Paul
Girl Kim
Silly Sally
Smarty Sally
Smarty Paul

 

[boblarson]

poporacer -

Given you've been around for a while now I am surprised that you have this as non-normalized. You really should have another table for the nicknames to handle the one-to-many relationship.

 

[poporacer]

I guess I am a little rusty, I have been workin on a different platform....that would work.

Thanks

And Damn...you are quick!

poporacer -

Given you've been around for a while now I am surprised that you have this as non-normalized. You really should have another table for the nicknames to handle the one-to-many relationship.