How to create a Lookup field in Microsoft Access 2013 using SQL?
<p>May I enquire as to how does one create a look-up field in a table in Microsoft Access 2013 (using the <strong>CREATE TABLE</strong> statement in SQL) which provides a drop-down box in Datasheet View that allows the user to select one or more entries in the field? </p>

<p>An example is as shown below (where the user can choose the fruit/(s) he/she likes from the drop down box in the <strong>Fav_Fruit</strong> field):</p>

<p><a href="https://i.stack.imgur.com/RgKlP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RgKlP.png" alt="enter image description here"></a></p>

<p>The values for the drop-down control are obtained from another table called <strong>Fruits</strong> (stored within the same Access database) shown below:</p>

<p><a href="https://i.stack.imgur.com/c5f0a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/c5f0a.png" alt="enter image description here"></a> </p>

<p>Please advise.</p>

<p>Thanks.</p>