Foreign key showing null value
<p>I am trying to show the foreign key value that is extracted from another table. 
The codes that i've used:</p>

<p>Code for first table:</p>

<pre><code>CREATE TABLE trip (
    tripID  INT(10) PRIMARY KEY,
    startTime   TIME,
    endTime     TIME,
    tripDate    DATE,
    price       VARCHAR(5),
    databaseID  INT(10),
    FOREIGN KEY (databaseID)
       REFERENCES databasestorage(databaseID)
);
</code></pre>

<p>code for second table:</p>

<pre><code>CREATE TABLE databasestorage (
    databaseID  INT(10) PRIMARY KEY,                    
    location        VARCHAR(40)
);
</code></pre>

<p>After inserting the values into both tables, in the <code>trip</code> table, <code>databaseID</code> still shows as <code>null</code> while all other columns are correct. How do i make it such that <code>databaseID</code> in my <code>trip</code> table shows the value of <code>databaseID</code> from the <code>databasestorage</code> table?</p>