Script for user lookup
2 part question:
Part 1: Currently running data separation method with all users created/validated by Filemaker (in both the data and UI file). I'd like to make a Users table to store some basic info: user name, Full name, email, maybe their extension or perhaps in the future, user preferences. For the time being, I'd like to have a field in my Quotes table autofill with the user's full name. How can I best achieve this?
Part 2: I will be deploying FM Server in the next couple months and switching over the accounts from FM based to Open Directory based. How, if at all, will those types of scripts change (the user names will not change between the two platforms)?