The term relationship - in the relational database world - refers to an association between 2 records

Note |

Did you notice that Access sorted the records after you added the lookup field?  The sort really has nothing to do with the lookup field; it just appears that way because the sort showed up after you added the lookup field, which is just a coincidence.  Access is actually sorting the records by the primary key values.  Because the primary key field is a text field (CommonName), Access sorts the records alphabetically.

Note |

It might not matter to you right now, but forms and reports inherit a table's lookup fields.  That means any forms or reports bound to the plant table will use a combo box - not a regular text box control, which is the default control - to display the TypeID field's contents. 

Note |

Wizard created your 1st relationship.

Note |

With the Enforce Referential Integrity option turned off, Access enables you to update any value or add and delete any records as long as you do not violate any datatype or validation rules.  You must turn on referential integrity to use it.  We recommend you not to use either of the cascading options unless you have a specific reason do do so, and then we suggest you never turn them on permanently.