hi,
I think foreign key doesn't work if the referecing column is not a Primary key.
Is there any work around for this ? I need to check the column value in a X table, before inserting data into a Y table; but the column in X tabe is not a primary key.