4 Replies Latest reply on Dec 8, 2009 11:54 AM by daveealex

    Auto enter location based on log in



      Auto enter location based on log in


      I am creating a database the will be installed in many locations. Each location may have a couple of users. What I would like to do is when a user creates a record it records the name (this can be done in auto enter data>creation>account name). Is there a way to connect this to a location?

      Example Alex is from Naples. When she logs in and creates an record, she gets recorded in created by and location Naples. Judy is from Paris, she creates a record and it gets recorded created by Judy and location Paris. This is needed for the search and for reports. I know it could be searched by the login name, but when printed we don't always want to see the name of the user we want the location. So how do I auto log the location of the user based on the user name?I am sure it can be done easly but i just can't see it. Thank you in advance. (using Filemaker 10  and Windows Vista)

        • 1. Re: Auto enter location based on log in
             Do these people travel or are they pretty much stationary to their locale? If they are stationary, then you can use a user table to store where they are located and based on their login, grab the data from that user table.
          • 2. Re: Auto enter location based on log in
               They are stationary. When you say user table, what do you mean? there is no personal info in the accounts/privileges except for the login and password. If I need to create it how will connect it to my main table so that is auto inputs the person and location?
            • 3. Re: Auto enter location based on log in

              Define a user table with at least two fields:


              AccountName and Location


              Define a matching AccountName field in your table with the Auto-enter feature you described


              Relationship in Manage | Database | Relationships:


              YourMainTable::AccountName = LocationTable::AccountName


              Now you've linked your two tables by account name. You can either use the above relationship to refer to the above location field dynamically or you can specify a "looked up value" option for a text field if you'd rather capture a "snapshot" of the location data as it existed at the time the record was created.


              [Edit fixed some minor typos]

              • 4. Re: Auto enter location based on log in
                   Thank you PhilModJunk. This worked perfectly. Sometimes the answers are so simple we don't see them. I think I am making things harder than they are. 2 thumbs up for PhilModJunk!!!