OnLoad update table depending on Y/N value of another table

Hello,

I need to update a field in a table that has 2 fields:

LaptopName
StatusID

I have another table called loans, in this table one of the fields has a complete Y/N value (depending on whether the loan is complete, i.e. returned laptop to me)

i need to make it so that “Onload” the statusID field of the laptops table is updated to “AVA” (avaliable) but only if the loan tables “complete” field is set to “Y”.

How is this done please? I think through the Onload command but am unsure?

If you could help id be most greatful

Thank You

Tom