How can I achieve the following:
I have a parent site with a Contacts List. There are columns for "First name" and "Last name", and I made a calculated column called "Full name" to display them both together using CONCATENATE, with the result as a text string.
In a subsite I want to lookup contacts using the "Full name" column from the parent. How can I achieve this?
As an extra layer, would I be able to filter the lookup column's options by a third field in the Contacts list? For instance, only showing the names of people where the field Job Title = "Manager".
Thanks in advance for any help!