change linked data

I have two table A and B, table A has product status variable that tracks the different phases of product and helps with different views to see specific inventory. Table A is also linked to table B, I would like to be find a way to edit table A’s status field from B once I am done processing it instead of manually going to A to change it. so far I couldn’t find a way to change. any advise is highly appreciate.