Related field value list not showing up in find mode
I have a table of animals with a current farm location and a current pen or group. Each field is in the same table of animals, I relate the current pen or group to a farm id in a separate table, which is related to a third table of pen or group defined by farm id. All relationships seem to be correct. It works fine in browse mode, but not in find mode. I get the dreaded "<no values defined>" error. I have the appropriate 'start from table defined', and the field with the related value list is selected in layout mode to be included in find mode. Where am I missing it?