How to populate a text box based on two combo box selections

[UTuser]

I'm not having much luck looking for answers in the archives for what it is I want to set up in my Access DB. If I could get some direction as to the function I should look at, this will be a big help. I hope I wont need my hand held for the step by step with this but some direction would be much appreciated.

I have a form with two unbound combo boxes. Their source is from two separate tables Names and Rooms. A third table "Incident" holds the results of selecting from a list of 395 names and 400 Rooms. Rooms to names have a one to many relationship. I want the results of selecting a specific name and a specific room to retrieve a text string based on the specific permutation. By this I mean, "Bob" assigned to room "J244" will return a different text string than "Bob" assigned to "J237"

I'm having trouble wrapping my brain around the relationship types as each Room can have several Names assigned to it and each Name can be assigned to several different Rooms.

Thanks in advance for your help.

[ChipR]

If Incidents are unique per Name + Room, then you would just have a table with Name and Room as combined primary key.
Once the combo boxes have values selected, you can use them to filter a subform of Incident, or just do a DLookup on the Incident table .