Authentication Form

[carterhobson]

Hello,

I am working on building an authentication form for my app. There will be two tables involved, one being the authentication table, and the other being the authentication keys table. The authentication keys table will have IDs in one column and a full name listed in the other column. The form will use Valid If expressions to verify the form by comparing the ID entered to an ID in the auth keys table, to grant access. I would also like to keep track of a full name in the authentication form possibly by ref or just to fill in the name, either way, I would like it to be automatic, so when you fill out your ID in the authentication form it will auto-fill your name or reference to your column in the auth keys form. Which expression would best fit for the auto-fill function?

Thanks for the Help!