Hi Jason,

Here is the example of my three relationships

// Agents // Relational Field
piklist(
	'field', array(
		'type'  => 'select',
		'field' => '_' . piklist::$prefix . 'property_owner',
		'label' => 'Owner',
		'choices' => piklist(
			get_users(
				array(
					'role' => '' // Todo: Set to agent
				)
			),
			array('ID', 'display_name')
		),
		'relate' => array(
			'scope' => 'users'
		)
	)
);

// Tenants // Relational Field
piklist(
	'field', array(
		'type'  => 'select',
		'field' => '_' . piklist::$prefix . 'property_tenant',
		'label' => 'Tenant',
		'choices' => piklist(
			get_posts(
				array(
					'post_type'   => 'tenants',
					'numberposts' => -1,
					'meta_query'  => array(
						array(
							'key'     => '__tenant_landlord',
							'value'   => get_current_user_id(),
							'compare' => '=',
						),
					),
				)
			),
			array('ID', 'tenant_firstname')
		),
		'relate' => array(
			'scope' => 'tenants'
		)
	)
);

// Agents // Relational Field
piklist(
	'field', array(
		'type'  => 'select',
		'field' => '_' . piklist::$prefix . 'property_agent',
		'label' => 'Agent',
		'choices' => piklist(
			get_users(
				array(
					'role' => '' // Todo: Set to agent
				)
			),
			array('ID', 'display_name')
		),
		'relate' => array(
			'scope' => 'users'
		)
	)
);

When I try run the following code I don’t get any results:

$related_properties = get_posts( array(
	'post_type'        => 'properties', // Set post type you are relating to.
	'posts_per_page'   => - 1,
	'post_belongs'     => $postID,
	'post_status'      => 'publish',
	'suppress_filters' => false, // This must be set to false
));

So for now I’m pretty much running the following to get it working:

$related_properties = get_posts( array(
	'post_type'        => 'properties', // Set post type you are relating to.
	'posts_per_page'   => - 1,
	'post_status'      => 'publish',
	'suppress_filters' => true, // This must be set to false
	'meta_key'         => '__property_tenant',
	'meta_value'       => $postID
) );

Not sure if I’m doing something wrong or misunderstanding the relationship concept. Appreciate the assistance 🙂

Ahh ok cool, got it now, thanks!

So then instead of __property_owner for the ‘field’, I should be using something like __relate_tenants, __relate_properties etc? Or will this always still be __relate_post?

Thanks Jason, really a big help! Will adjust my code and give it a try.

On the frontend form, the relation “saving” doesnt seem to work. I added a scope with post_meta as the value so that it gets saved. The relation however is not working. It only works when I save it from the backend. Is there anything special to add for relationships on a frontend form?

piklist(
	'field', array(
		'scope'      => 'post_meta',
		'type'  => 'select',
		'field' => '_' . piklist::$prefix . 'property_tenant',
		'label' => 'Tenant',
		'choices' => piklist(
			get_posts(
				array(
					'post_type'   => 'tenants',
					'numberposts' => -1,
					'meta_query'  => array(
						array(
							'key'     => '__tenant_landlord',
							'value'   => get_current_user_id(),
							'compare' => '=',
						),
					),
				)
			),
			array('ID', 'tenant_firstname')
		),
		'relate' => array(
			'scope' => 'post'
		)
	)
);

Setting the scope to post didn’t work. It doesn’t save the field “__property_tenant” as meta. When set as post_meta, the meta saves at least but the relationship is unchanged and still uses the previous item that was set as the relation.