Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Related Record (11.8166.8172 (2003))

    I thought I was creating a very simple database w/ form however I am not seeing what my problem is. Attached are screen shots of relationship, form and error message. Any help appreciated.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Related Record (11.8166.8172 (2003))

    You cannot enter any data into the subform before you have created a record in the main form. The Employee Name combo box in the main form is empty so I assume that there is no record in the main form yet. Try selecting a name in the combo box, then entering some data in the subform.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Related Record (11.8166.8172 (2003))

    The Employee name combo box does have a listing of names.
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Related Record (11.8166.8172 (2003))

    I'm afraid that doesn't say very much. Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Related Record (11.8166.8172 (2003))

    The join on those tables, are they on EmployeeID to EmployeeName??

  6. #6
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Related Record (11.8166.8172 (2003))

    yes.
    Attached Files Attached Files

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Related Record (11.8166.8172 (2003))

    Well it should not be.
    In tblVisit replace the EmployeeName field with an EmployeeID field (long integer) and use that field in the relationships to connect tblVisit with tblEmployee.
    Regards
    John



  8. #8
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Related Record (11.8166.8172 (2003))

    Here is a stripped down copy.
    Attached Files Attached Files

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Related Record (11.8166.8172 (2003))

    Both the main form and the subform are based on tblVisits. This makes no sense. The main form should be based on tblEmployee, and the subform should be linked to the main form on EmployeeID - you want to see the visits for an employee, I presume.

    See attached version.
    Attached Files Attached Files

  10. #10
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Related Record (11.8166.8172 (2003))

    Thank you very much. Your response was how I had attempted however was not sure that it was correct. Again, Thanks!

    Another issue. Attached is a snapshot of the last page of a report where I would like a summary of various codes for each of the month and a total. I tried count and DCount in various ways but have not come up w/ the right combination. Suggestions, please.
    Attached Files Attached Files

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Related Record (11.8166.8172 (2003))

    You can use crosstab queries for this. However, the column headings in a crosstab query can change over time, and this makes it more difficult to base a report on such a query. If you search this forum for dynamic crosstab report, you'll find examples.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •