Noob trying to make a one to many relationship?

[Zulrock1]

So I may not be asking this question correctly. (I'm pretty much a noob) I need to set up a query to look up values from one table (table R) based on the value in a column of another table (table F). I've set up a dlookup function in a query that contains the necessary info from table F the issue is that I need to be able to use multiple dlookup functions with the same deterministic value ini table R but using different values in table F.



Essentially I need to have multiple columns utilizing the dlookup function using the same primary key in table R but different values from table F.

Im not sure I even have the knowledge to frame this question correctly but I was hoping for some help.

[ranman256]

you DONT use dlookup in a query. The query IS the dlookup.
You put both tables in the query and join them on the common field. This does the dlookup.