Auto-update a field based on input from previous field

[IdrisJamilAfif]

Dear All,

My issue is quite simple yet I cannot get round to it myself

Basically, in Access, I have a table which holds all flight details such as Flight Number, Operator, Aircraft Type etc.

I would like to include a field: Airline Logo

This field would automatically be updated depending on the Operator entered previously.

I was thinking I could create a table for all Airline Logos and link it to the Operator from the flight details table.

Is that possible? If so, how?

Awaiting any response from anyone around the world

Kind Regards,

Idris