Avatar of bejhan

asked on 

Reference a non-keyed column

Is it possible to create a table which has a column (A) which references a column (B) in another table which is not a key. I want to make sure that each value in A contains a value found in B. I suppose a many-to-many relationship.

I have done this in MS Access before but I'm not sure how to construct the SQL statement to create the table. I tried using foreign key, which didn't work because B is not a key.

Avatar of undefined
Last Comment

8/22/2022 - Mon