Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010
    Posts
    8

    Unanswered: Retrieve Data based on Keys.

    Hi,

    I have a table in oracle that holds Foreign Keys(FK) like....


    Hour_id(FK) Hours

    1 08
    1 06
    1 02

    and so on...

    If i drag and drop the Hour_id in report then it should retrieve the rows of Hours based on the Primary key(PK)- Hour_id......

    Please help me with this......

    Thanks in advance.....
    Last edited by Ram2Curious; 07-19-10 at 16:46.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Ram2Curious View Post
    I have a table in oracle that holds Primary Keys(PK) like....
    i can't help you with your crystal reports problem, but i would like to point out that Hour_id cannot be the PK, because there's more than one row with the same value (1) and PKs must be unique
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2010
    Posts
    8
    Can someone guide me with this........

    thanks.....
    Last edited by Ram2Curious; 07-19-10 at 16:48.

Posting Permissions

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