I would like to create a useful dropdown for our growing contacts table.



at the moment I have 2 fields I'd like to select from: Supplier Name and Supplier Type.

my table contains for example

ID Supplier Name Supplier Type
1 Allans Plumber
2 Desperate Ms Canoe Shop

I'd like my drop down to look like this:

Allans, Plumber
Canoe Shop, Desperate Ms
Desperate Ms, Canoe Shop
Plumber, Allans

Just gives you more visual look up options.

What query will give me this doubled up list?

many thanks

Phil