LINQ query to join 2 datasets and return matched field

Hi Guys, this will take some explaining, but hopefully the solution wont be so complicated.

I'm receiving a message (Via an event) the message has a Dictionary property called fields.

The fields can be as:

(Dictionary)
String
Key                        Value
UpdatedValue      "Email Address"

Name
Key                     Value
FistName            "Persons First Name"
Surname            "Persons Surname Name"
Title                     "Persons Title"

Address
Key               Value
Address1         "64 The Road"
Address2         "Westminster"
Town                  "London"
Postcode.         "W145QW"

At the time the message is received I wont know what is in the message.fields.

The message also includes a separate key to match up with database fields in the Key Column above. I'm using a DAO query to pull back a recorset  that looks something like this respectivly.

(DAO recordset Object)
String
QuestionKey      Key                     ID      LastUpdated      
String               UpdatedValue   200      2021-12-01

Name
QuestionKey      Key                  ID      LastUpdated      
Name                  FistName      167      2021-12-01
Name                  Surname      168      2021-12-01
Name                  Title               169      2021-12-01

Address
QuestionKey      Key               ID            LastUpdated  
Address            Address1      167         2021-12-01
Address            Address2      168         2021-12-01
Address            Town               169      2021-12-01
Address            Postcode         115      2021-12-01

So I have 2 sets of data, a dictionary of keys and values, and a DAO with keys and Id's.

I'm looking to LINQ to iterate over the Dictionary and for each item get me the id and LastUpdated date based on matching Keys. (I pass these values into a method to do stuff with.)

Andy