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?
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.