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

[yandoo]

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