I'm building a feature into the front page of my site where users can customise a set of links that they want on there. I'm having some trouble getting the results in a usable format!

In Access I have 2 tables. One with the users individual ID (which it automatically picks up from their log in details <- this will be used for the filter) and link1, link2, link3 etc. The other table contains information about the links, e.g. LinkName, LinkURL, LinkID. I want the LinkID in the second table to join to each link column in the first table.

Ideally I would like a query produced from these tables to just display UsersID, LinkName, LinkURL.

Is this possible?