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.
- 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?