There isn’t anything that will allow you to filter a relationship field based on a selection made in another field. The value of the other field is not available for the
acf/fields/relationship/query/ filter, it is not supplied by ACF when it runs the AJAX request to get the posts.
There are a couple of possibilities.
1) is that you must save the post before you can filter based on this other field. Then in your filter that you posted above
'value' => get_field('filter_field_name', $post_id)
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
Sorry for the issues with ACF's API SSL certificate this morning. We've resolved it and your activations and downloads should be back to normal again. Thanks! ^LG— Advanced Custom Fields (@wp_acf) November 2, 2022
© 2022 Advanced Custom Fields.