Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    11

    Unanswered: updates for projects arranged by ID (was "Help needed - I don't know where to begin")

    I have a Access database wich I'm using to generate ASP pages. There are two tables such as those below:

    HTML Code:
    Tbl_Project
    
    ID     Name        Date
    
    1      Project a   01/03/06
    
    2      Project b   01/12/06
    
    3      Project c   05/03/06
    
    4      Project d   21/03/07

    HTML Code:
    Tbl_Update
    
    ID     Problem       Date of problem 
    
    4      Too high      15/06/06
    
    3      Too low       01/12/06
    
    2      Too Short    05/03/06
    
    4      Too Long     21/03/07
    
    1      Too soft      19/12/07
    
    3      Too hard      30/09/06
    
    4      Too slow     18/04/07

    I want to be able to see all the updates for all the projects arranged by their ID. So I would get something like:

    HTML Code:
    ID 1 
    
    Problem - Too Soft
    Date of problem - 19/12/07
    
    ID 2 
    
    Problem - Too Short
    Date of problem - 05/03/06
    
    ID 3 
    
    Problem - Too low
    Date of problem - 01/12/06
    
    Problem - Too hard
    Date of problem - 30/09/06
    
    ID 4 
    
    Problem - Too high
    Date of problem - 15/06/06
    
    Problem - Too Long
    Date of problem - 21/03/07
    
    Problem - Too Slow
    Date of problem - 18/04/07

    The important part here is having all the problems for for a specific ID listed together without the ID appearing again as above. Any suggestions or pointers greatly appreciated.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    "... without the ID appearing again"

    use a simple join, and do this "prettifying" in ASP
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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