2 Replies Latest reply on Feb 23, 2010 4:23 AM by ekm12

    Passing Values from external database

    ekm12

      Title

      Passing Values from external database

      Post

      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,

      EKM12