Probably the easiest way to do this would be to define a global calculation field in the current table as Get ( AccountName ). Set the storage to unstored ("Do not store calculation results"). Then, make a relationship between that field and the account name that's entered in the target table (i.e., the one where you want to filter). Base your value list on that relationship.
Thank you, that worked for me.