4 Replies Latest reply on Jul 15, 2009 2:14 PM by etripoli

    Pls help a noob!

    piedpiperx

      Title

      Pls help a noob!

      Post

      I'm totally new to filemaker PC...

       

      I think I'm trying a simple task but don't know how.

       

      I would like to create a simple "Time Track" database for my very small compnay

       

      Here is what I need it to do!

       

      Have a layout, where the admin would plug in data such as

       

      -Employee name

      -Client name

      -Project (code name)

      -Task performs

       

      Now there would be a separate layout where employees would plug in data using selections from from what the admin plugged into the database

       

      So the employee would select from dropdown list

      -Employee name

      -Client name

      -Project name

      -Task performs

      -Start time (in hours)

      -end time (in hours)

       

      Here is where I'm lost

       

      I need it to be smart

       

      -Project name should be related to client name, so as an example, the drop down list would only have project names that are specific to the client

       

      example

       

      DB

      Client name

      -Companie 1

      --REX

      --TAB

      -Companie 2

      --SOD

      --HEX

       

      So in the the employee layout when the employee selects client name, the only option that should appear in the dropdown list is:

      -company 1

      -company 2

       

      So the employee selects "company 2" - next for project name only data that should appear in the drop down list is:

      --SOD

      --HEX

       

      Make sense?

       

      I will monitor this tread all day...and will answer or clarify any questions that may arise.

       

       

        • 1. Re: Pls help a noob!
          etripoli
            

          Makes perfect sense, but it's not necessarily easy to do.  You'll need at least 4 tables: Employees, Clients, Projects (& possibly tasks ), and Tasks Performed.  FM will automatically create a layout for each table.  Most of these you'll want to hide from the regular employees, either through access privileges or unchecking the 'Include in layout menus'. 

           

          You'll then need to create the layout for the employees to use when entering tasks, and this is the tricky part.  It's going to involve scripting, dynamic value lists, and the proper relationships.  Feel up to the task?

          • 2. Re: Pls help a noob!
            piedpiperx
              

            Most definitely – I will do whatever you say… this will be great working this out.

             I'm all ears!

             

            • 3. Re: Pls help a noob!
              piedpiperx
                

              Cool I have the 4 tables created and each has one field using the same name as the table

               

              -Employee = filed Name

              -Client = field client

              -Project = field project

              -Task Performes = field task

               

              Did I do this right?

              • 4. Re: Pls help a noob!
                etripoli
                   Sent you a pm with a link to a sample db.