Retrieve Data based on Keys.

Ram2Curious · #1 (**permalink**) 07-19-10, 10:33

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.....

r937 · #2 (**permalink**) 07-19-10, 14:34

Quote:

Originally Posted by Ram2Curious

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

Ram2Curious · #3 (**permalink**) 07-19-10, 15:32

Can someone guide me with this........

thanks.....

Internet Services

Web Development

Digital Marketing

Consumer Tech