Results 1 to 5 of 5
  1. #1
    cooper is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    24

    Relationships/Joins/Forms STUCK

    Hi guys,

    I have been stuck on this database for a very long time. I know the solution might be really simple, but because of my lack of knowledge in access i am not able to make it happen.

    i have attached the database here so please have a look if you can

    what I want to do is ask the user to enter values for "Total Available" and "Total Actioned" for each activity. This task will be used daily so new values should be stored under the activity.

    Forexample, in the DaysOnly tab I want to show all the DaysOnly activities to the user and let them enter values for Total Available and Total Actioned for each day...

    I am so confused in what joins to use, what structure and I have been unsuccessful like 100 times...

    I would really appreciate if someone can let me solve this ..



    thank you!!

  2. #2
    cooper is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    24
    any one here willing to help please? (((

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Go to the design view of your FORM1

    Delete the RECORD SOURCE you have

    put this sql statement in instead:

    SELECT tblActivities_Act.*
    FROM tblActivities_Act;

    Re-establish the link between your main form and subform and it will work. Your FORM1 had too many tables that were useless to your data entry and on top of that did not include a field that would allow you to establish a link between the parent and child form (which in your case is employee_ID)

  4. #4
    cooper is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    24
    thanks for your help

    i did as you said, but there is something wrong - how do I populate the data according to the Activity as well.

    i mean an ideal situation would be that Activities Name is on the form, and then user can add values for total available and total actioned. Since this is a One - Many relationship, multiple values can be store. any insight into this?

    the employee relation works well - thanks!!

  5. #5
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    the activity will likely have to be a combo box because you have no activity ID on your main form to which you can link. Just add a combo box to your subform, have it look up values from your activity table, make sure the primary key is the bound column and hide it (make it a width of 0) then as you're doing data entry you can just type in the start of the activity text and it should fill up with whatever you have in your database that matches what you're typing.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-14-2011, 07:56 PM
  2. Replies: 0
    Last Post: 03-13-2011, 06:46 PM
  3. Help I am stuck
    By Darkglasses in forum Database Design
    Replies: 10
    Last Post: 03-04-2011, 09:10 PM
  4. Need Help with Joins
    By usa_dreamer2002 in forum Queries
    Replies: 3
    Last Post: 01-31-2011, 10:58 AM
  5. Record relationships in forms
    By avarusbrightfyre in forum Forms
    Replies: 2
    Last Post: 09-10-2009, 04:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums