2 Replies Latest reply on Aug 10, 2009 5:28 AM by Marky1

    multiple users with global fields

    Marky1

      Title

      multiple users with global fields

      Post

      Hi,

      I am still trying to learn the basic techniques in filemaker so any help is really appreciated.

       

      I have a table for time sheets with the fields; Start time, End time, Duration, Activity, Code, Date, User.

      There needs to be support for multiple users, i have set up accounts in Accounts & Privileges.

       

      You edit one date at a time and add activities to that date, so every record has a date and user field with it, so to show the correct records for the current date i do a find. with left and right buttons to change the current date.

       

      To view what date you are currently editing i added a global field "Current Date Viewed" in a "Variables" table and set up a Merge Field to display it, this global field was kept in sync with a global variable $$currentDateViewed which i used to do the find.

       

      My problem is with multiple users i dont think i will be able to use the global field and global variables as when one user changes their date the another user will be effected.

      I tried to set up a "Staff Details" table with Username and its own "Current Date Viewed" field exept with this i cannot do a find because its in an unrelated table.

       

      Any help would be great and also any hints on wether my method is the preferred method for sorting different users data.

       

      Thanks, Marcus