Relationships and lookups

[north19701]

I have a query where one column is titled Carrier. It lists the carriers we submit claims to. I have another table called Carrier Listing that contains the Carrier and Payor Group. What would I need to do to create in the query a lookup to associate the payor group with the carrier? If this doesn't make sense, the best I can equate it to is a vlookup in Excel where the lookup would compare the carrier name and take the Payor group associated with it and plug it in. Thanks if anyone can offer help.

 

[NitherWise]

Try searching on DLookup in the Access help file. I think that is what you want. I would try to explain it here, but I think the help file does a better job than I could.

Here's an example of one that I have used:
=DLookUp("[CustName]","qryCustomerList","[CustNo] ='" & [Forms]![frmIssuesBrowse]![cboCustNo] & "'")

 

[north19701]

thanks for the input, actually, i just created a query using the Carrier Listing table and created a relationship to the carrier in the original query. Thanks.