Results 1 to 5 of 5

Thread: Need to use two queries

  1. #1
    Join Date
    Apr 2007
    Posts
    38

    Need to use two queries

    Hi

    I open TeacherDetailFrm by double click on the FirstNameTxt, FirstNameTxt on subform using Mainform.
    TeacherDetailQuery is record source for TeacherDetailFrm and subform.

    I need to use two queries, one for TeacherDetailFrm and second for subform.
    when I use two queries data not appear.

    If you need file attach for more information, I will do.

    thanks

  2. #2
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    I gave you a solution to your request a couple of weeks ago. Why are you starting again. Did the solution fix your problem or do you need more assistance?
    Allan

  3. #3
    Join Date
    Apr 2007
    Posts
    38
    Hi Allan Murphy

    Thank you so much,
    yes; you help me and you solve my problems but still I need help for other problems.

  4. #4
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    Quote Originally Posted by SAMI2
    Hi Allan Murphy

    Thank you so much,
    yes; you help me and you solve my problems but still I need help for other problems.
    What other problems are you having as you are posting the original problem on various forums (website)?

    As I said on the other forum you need to include a foreign key to show the teacher that has the student.
    Allan

  5. #5
    Join Date
    Apr 2007
    Posts
    38
    Hi Allan Murphy

    yes you are right solved the problem by foreign key, I am still develop my plan, when I need help I will make new thread.

    thank you so much for help, your time and effort.

Posting Permissions

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