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.
I have created a Cabin Table with Location ID as FK, I can't select Location ID from the drop down list.
However, when I inspect the table, it has locationID as column
Any idea? Am I missing something?
Thanks in advance, I checked on the web and couldn't get anything substantial