Unable to insert FK value to a table

15 views Asked by At

I am trying to insert values to a table that has a FK from other table. In my example

I have created a Location Table and insert values.

enter image description here

I have created a Cabin Table with Location ID as FK, I can't select Location ID from the drop down list.

enter image description here

However, when I inspect the table, it has locationID as column

enter image description here

Any idea? Am I missing something?

Thanks in advance, I checked on the web and couldn't get anything substantial

0

There are 0 answers