I have table of Member and a table of Appealss. On Member record I have field "Responded" that I want to have a dropdown list and the only options that should come up are the Title fields from the Appeals related (mailed) to this Member. RIght now it appears to list all Titles from all Appeals for all Members, even though I am using a relationship of key to key. I selected use values from field, if I select Include All Values ( I would think from only related records) it shows all values from all (even unrelated) records. If I select "Include only related values starting from" I don't understand why I can't select the same relationship. I don't understand what this is supposed to enable. The help doesn't seem to cover this.
But anyway, how can I get the dropdown to only show the values from records that are related to the parent record?