Thanks, that's what I think. I got a database from a client who has 2 identical table structures (not in Oracle database though). I just wondered how was the relationships set up in that database and now transfering into oracle. I think one way I can do is to create another unique field then combine these two tables together into one. Thanks for your help.

-U