Check out our brand new Local Poker Communities! Get updates and interact with poker players in your area.
Visit the United States Poker Community | Visit the California Poker Community | Read more about the Launch of P5s Local

Access Database Help

Reply to Thread
  1. Ma Zi Yi Ma Zi Yi is offline

    Posts: 1,477
    Joined: Aug 05

    Dec 17th, 2009 (12/17/2009 4:55pm)

    <span>I am making a table that will record the daily tasks of a production team. The production is split into 4 groups that each have different tasks. One person may perform tasks in all or some of the different groups for the day. </span>

    <span>The users want to be able to go to 4 different forms and enter the information into the different fields only pertaining to that group.
    </span>

    <span><img width="581" height="509"></span>

    <span>The problem is that the 4 different groups would make 4 different records. So there would be 4 duplicate fields for each day, 3 of them would be 0. </span>
    <span>
    One solution is that we would have only 1 field, with a drop down box with each of the old fields now as a record.<span> But this is not user friendly...</span>

    <span>We want to keep one record a day per person. Do you know how we could open 4 different forms, like pictured above, with totally different fields, but from the same record?</span>

    For Example: the Fields would be Name, Date then the Task A, B, C, D, E, F...

    I want the # of times TASK A,B,C was done to be entered onto one form. And DEF to be entered on a different form, but they all link to the same record.

    <span>Thanks for your help. </span>
    </span>
  2. TheDeparted 1 TheDeparted 1 is offline

    Carbondale, IL
    United States

    Posts: 1,459
    Joined: Dec 07

    Dec 17th, 2009 (12/17/2009 5:15pm) in reply to Ma Zi Yi

    http://www.wrcbtv.com/global/story.asp?s=11689145
  3. kmax9 kmax9 is offline

    South Bend, IN
    United States

    Posts: 343
    Joined: Feb 07

    Dec 17th, 2009 (12/17/2009 5:36pm) in reply to Ma Zi Yi

    Why don't you make index tables for each group that are able link to the 1 record from the main daily table. I am a little confused on what is going to each group.. And it sounds like you are also designing the front end... ?

    Sounds like you could have buttons linking to each group after adding the day or edit.

    And display each task name in multi-drop down box, and add and delete from the there...

    Not sure if this is where you are going.
  4. Ma Zi Yi Ma Zi Yi is offline

    Posts: 1,477
    Joined: Aug 05

    Dec 17th, 2009 (12/17/2009 6:15pm) in reply to kmax9

    There is one team, split into 4 groups.

    They each do different tasks, and they record every day how many times to do the task. They could do tasks in multiple groups though.

    At the end of the day they have to enter in the totals for all the different tasks they perform, sometimes 10+ tasks in most of the groups.

    I don't know how I could link the tables, if I split them, so that the different groups would link up into one record.

    Yes I am doing the front end also.

    -- I can start this from scratch so any tips are greatly appreciated
    Thread Starter
  5. conartist21 conartist21 is offline

    San Francisco, CA
    United States

    Posts: 759
    Joined: Sep 09

    Dec 17th, 2009 (12/17/2009 6:18pm) in reply to Ma Zi Yi

    http://www.salesforce.com/
Reply to Thread

Similar Threads