how to make an Update trigger capture the foreign key text value

[Jabba007]

I have an update trigger on a table called 'tbl_br' that is used to audit column changes and populate those changes into an audit table called 'tbl_audit'. See an excerpt of the code below:

Declare @LoginId as nvarchar (8)
set @LoginId = dbo.fnGetLoginId()
 
Declare @status_id_new int
 
Declare @id_old as int
Declare @status_id_old int
 
Select  @id_old  = (Select id from Deleted)
Select  @status_id_new  = (Select status_id from tbl_br where id = @id_old)
 
Select  @status_id_old  = (Select status_id from Deleted)
 
if isnull(@status_id_new,0) <> isnull(@status_id_old,0) 
begin
Insert into dbo.tbl_Audit(changed_on, changed_by, table_name, table_Record_id,  Field_Name, Old_Value, new_Value)
values(Getdate(),@LoginId,'tbl_br', @id_old, 'status_id',  @status_id_old,  @status_id_new)
end

The problem with this code is that it inserts the numeric value of 'status_id' instead of the actual descriptive status text value from the table 'tbl_status'. Since audit reports will be run regularly by end-users for various reasons, we would like to show the text value of the foreign key instead of the id. I know there needs to be a join to the foreign key table (ON tbl_status.id = tbl_br.status_id) to get the text value, but I'm not certain how exactly this should be written.

Any insight is greatly appreciated!