Need some help please

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Eric
    #1

    Need some help please

    There are four tables in my database, three are connected with the
    TicketNum(Tbl_P PVResearch,Tbl_ ValidDispute,tb l_Events). I create a
    parameter form where user select the accountnumber. There are four
    account in my parameterform(o ne from
    Tbl_PPVResearch ,3 from Tbl_ValidDisput e). I need help here user select
    one or more then one account and also type the technician ID. Once
    account numbers are selected and technician ID is typed it press the
    search button and the query has to go to Tech_ID table and match the
    first five digit of account numbers with corp and also the Tech_ID.tech
    once both match it print the report

    REPORT
    ------
    txt,AccountNum, OtherAcct1,Othe rAcct2,OtherAcc t3



    Tbl_PPVResearch
    ---------------
    TicketNum Autonumber PK
    AccountNum Type Text 00000-000000-00
    FS_TechID1 Type Text 00000
    FS_TechID2 Type Text 00000
    FS_TechID3 Type Text 00000

    Tbl_ValidDisput e
    -----------------
    TicketNum Number
    LstVldTech Type Text 00000
    OtherAcct1 Type Text 00000-000000-00
    OtherAcct2 Type Text 00000-000000-00
    OtherAcct3 Type Text 00000-000000-00

    tbl_Events
    ----------
    TicketNum Number
    txt type Text


    Tech_ID
    -------
    ID PK
    CORP Type Text 00000
    Tech Type Text 00000
    TECHCONT Type Text

    Tags: None
    • pietlinden@hotmail.com
      #2
      Re: Need some help please

      Normalize your tables, then use the OnNoData event of the report. It
      won't open if it has no data.
      Why do you have Tech(1,2,3) and the like? These should be child
      tables. How do you create joins if you have account and tech numbers in
      three different fields? You're making it really hard to design your
      database so it works for you if you do this. Yes, you _can_ union all
      this junk together, but why? Why not just build it right to begin
      with?

      You might want to read Database Design For Mere Mortals by Michael
      Hernandez, or the discussion on Normalization by Roger Jennings in his
      Que book on Access. It's in the first 100 or so pages, I think. (It's
      been a _long_ time, but his explanation of how to normalize is
      _excellent_).

        Comment

        • Arno R
          #3
          Re: Need some help please

          Eric,
          Why are you STILL not listening ??
          Please do NOT multipost !!!!

          If you *have to* then crosspost.
          Multi-posting really is wasting people's time.

          Arno R


          "Eric" <ehtisham@gmail .comschreef in bericht news:1157426547 .768089.37360@7 4g2000cwt.googl egroups.com...
          There are four tables in my database, three are connected with the
          TicketNum(Tbl_P PVResearch,Tbl_ ValidDispute,tb l_Events). I create a
          parameter form where user select the accountnumber. There are four
          account in my parameterform(o ne from
          Tbl_PPVResearch ,3 from Tbl_ValidDisput e). I need help here user select
          one or more then one account and also type the technician ID. Once
          account numbers are selected and technician ID is typed it press the
          search button and the query has to go to Tech_ID table and match the
          first five digit of account numbers with corp and also the Tech_ID.tech
          once both match it print the report

          REPORT
          ------
          txt,AccountNum, OtherAcct1,Othe rAcct2,OtherAcc t3



          Tbl_PPVResearch
          ---------------
          TicketNum Autonumber PK
          AccountNum Type Text 00000-000000-00
          FS_TechID1 Type Text 00000
          FS_TechID2 Type Text 00000
          FS_TechID3 Type Text 00000

          Tbl_ValidDisput e
          -----------------
          TicketNum Number
          LstVldTech Type Text 00000
          OtherAcct1 Type Text 00000-000000-00
          OtherAcct2 Type Text 00000-000000-00
          OtherAcct3 Type Text 00000-000000-00

          tbl_Events
          ----------
          TicketNum Number
          txt type Text


          Tech_ID
          -------
          ID PK
          CORP Type Text 00000
          Tech Type Text 00000
          TECHCONT Type Text
          >

            Comment

            Previous template Next
            Working...