Databases Reference
In-Depth Information
INSERT INTO 'countries' ('country_code', 'description') VALUES ('uk',
'United Kingdom');
We will now link this table to the
authors
table. Firstly, in
Relation view
for the
countries
table, we specify the field that we want to display:
Then, we add a field with the same name,
country_code
, to the
authors
table,
and in the Relation view, we link it to the newly created
countries
table. We must
remember to click
Go
for the relation to be recorded. For this example, it is not
necessary to enter any country data for an author, as we are interested only in the
relational schema.
Search WWH ::
Custom Search