Can Sql/access Display Foreign Key Rows As Columns?

I have an MS Access table that has a many-to-one key to another one, and I would like a query to display those items in one row. For example, Foo, Bar and Baz link to the row with

Solution 1:

Look at Access's PIVOT TRANSFORM.
I think that is what you will need.