Exclusively select one record from a connected Object

How do I configure two connected objects (with a One-to-One relationship) so that a user in the Live App can see and select to make a connection to only those records in the connected object that have not already been connected?

Hi Steve

This is actually quite easy to achieve (if I have understood you correctly).

I have set up a new Object called one to one example:

It has a one to one connection to Companies.

Now in the Companies Object set up a Text Formula field which picks up the value of a field in the connecting record:

You are then able to use whether this field has a value or not to filter the available records in your drop downs on your forms:

I hope this helps?


Thanks again, Julian. Yes, that works and is a great solution. I needed the reverse reference anyway… and it all makes perfect sense.
Cheers. Steve