Lets say I have the follow Tables:
Outfits: ID | Top Color ID | Bottom Color ID 1,2,1 2,3,4 Colors: ID | Name 1, Red 2, Blue 3, Green 4, Orange
I'd like to have a query in design view to have the following result
Outfit ID | Top Color Name | Bottom Color Name 1, Blue, Red 2, Green, Orange
In design view, I can link "Color ID" to "Top Color ID" and "Bottom Color ID" but I don't know how to specify in the GUI to create "Top Color Name" and "Bottom Color Name"