I have used the above formula to connect to another database and display all the information via the surname.
All this information is diaplayed in the "Surname" field on a new form that i have created.
The problem that Im having is that all the contacts within the other database is being displayed. With the new database Im making, I would like it so that when the new form is opened, it will identify who the user is and automatically pull the users contact name into the 'Surname' field.
I have a field on my form that displays the users name when a form is opened by using this formula: -
So i was wondering if it is possible to pull that specific users contact details?