You may want to refer to the ACF article on querying relationship fields.
Relationship fields are storing an array of data, not names of items selected, so you’re usually finding them by ID. I’d find the ID of branding then adjust your query to something like:
$brandingID = X; // replace X with the post ID of branding
$case_args = array(
'post_type' => 'cases',
'posts_per_page' => -1,
'orderby' => 'menu_order',
'order' => 'ASC',
'meta_query' => array(
array(
'key' => 'work',
'value' => '"' . $brandingID . '"',
'compare' => 'LIKE'
)
)
);
Depending on where you’re using these types of queries, you may want to adjust $brandingID in the query to something like a get_the_ID() call if you’re putting this query on each work post type as you’d understandably not want to hard code an ID in that type of instance and you’d want the ID to instead just reflect whatever the post type is you’re viewing.
