Passing Values from external database
I have a question I'm hoping someone can help me with...
I am using FMP9 on a MAC.
I have an application where the users use a shared account for reviewing & updating data but for Visit logs they want the ability to initialized who opened the log without anyone be able to overwrite the initials.
I created an external database with the individual accounts and passwords, when the request to open a Visit Log occurs, I open the database, which of course prompts for the account and password, I create initials based on the account name and send the value back to the calling script using global variables.
My problem is, the return variable is empty. Can anyone think of what I may be missing?
I sure hope this is making sense.
Thanking you in advance,