Thank you guys so much for the responses. It turns out I found a solution (albeit a bit convoluted) just before I received Rabbit's response.

I created an additional field in TextTbl called 'KeywordID' to store the priority of the keyword. Then I initialized that field to max(Keyword.ID) +1. The following query ensures that the TextTbl.Keyword field is populated with the keyword of highest priority (lowest KeywordID).

...

Good point. I'll be sure to implement that.

I'm still working to figure out the other problem of populating [TextTbl].[Keyword] with the keyword of highest priority. I'm beginning to think I may have to use VBA, but am unfamiliar with how to use it, so it's a bit overwhelming at the moment!

I have a table (TextTbl) containing several text fields, and a table containing a list of keywords (KeywordTbl), ordered by 'priority'. I would like to populate a TextTbl.Keyword field within each record to contain the highest-priority keyword found within its text fields.

I have written the following query:

...