Hi Jennifer,
Mark would be correct when you base a field on another field it isn't pulling the list from the field settings it is instead pulling each option that exists within that table for that field. So for example if your field has 8 choices but within the existing records you have only ever selected 2 of those choices when you use this setting you would only pull in those two choices into the field. So most likely what is missing is options in the field settings that have no corresponding record. I agree with Mark I usually caution people against this option as it doesn't always create eh synchronicity between the two fields people are looking for and many times people use this to try to achieve a relationship but it doesn't have the functionality of a relationship.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
