Hi all,

Coming from an Access background here so a few kinks to iron out.

I have an application with Form 1 that is:

Initials (Autocapitalise)

Postcode (Checks details are correct)

UniqueID (Initials+Postcode) updated on form submission

I then have Form 2 that would be used for sessions with the Unique ID as the lookup

What I want is a pre-form that allows me to manually enter Initials and Postcode which then opens the sessions form with the UniqueID already selected based on that form. I want to do it this way so I don't have a drop down and if someone enters the incorrect details they can't access the session form.

Any help would be great.