You could do this with an automation: 1. Trigger when record matches condition - Condition = When "User Role" = "Job Seeker" 2. Action is "Update Record" - Updates the triggering record by pasting the "Full Name" value into the linked field to the "Profile" table
This way the "Profile" table will only include records where the "User Role" value is "Job Seeker". After that, you can create a lookup field to get the "Avatar" field like you wanted
Note that this won't update though, i.e. if the "User Role" changes in the "User Account" table, the record will still remain in "Profile".
I'm curious why we can't use filters for this though. It seems like if you filted by "User Role" = "Job Seeker" you'd get exactly what you want?