Linking Lists in SharePoint 2010 programatically

Question

How would I link two lists so that one pulls in a set of data from another and populates a dropdown list in the first list for you to select from.

Example:

• List A contains a drop down called fruit.
• List B contains a column (field) called name with names like apple, banana, passion

List A's drop down should pull from List B and populate its drop down using the contents of "name" from List B.

How would I do this programatically?

Answer 1

This is called a Lookup Column. The column can be created and configured in the UI, via Powershell, or via code.