Updating the Status and user when equipment is loaned

[Brodiecooke]

I have two tables Assets and Hardware Assignment (HA). You are able to loan hardware out ot users which adds a row to Hardware Assignment. The hardware the is available for loaning is based on the table Assets.
I would like to update the status on Assets when the Hardware Assignment Form (Adding a row to HA) is filled out.
I currently have the Serial number of the device being pulled from the Assets table into the HA as an ENUM.
This pulls over the Item Name and Asset Tag into the HA Form. 

I am totally lost on how to do this, I have watched a few videos and can't get it to work

[Marc_Dillon]

You can:

1. Set up a Virtual Column on Asset table to automatically calculate its status based on the other table.
2. Run an "execute an action on a set of rows" action from either:
   1. Form Save 
   2. Bot

[Brodiecooke]

could you explain these options a little more?

[Marc_Dillon]

This is one of the most asked questions in this forum. Try searching for "update other table".

[Brodiecooke]

Thanks...