I have one form with fields for the names of the members of a family: Mothers_Name; Fathers_Name; Sibling1; Sibling2; Sibling3. There is also a field for Family_Id.
On another form I would like a dropdown to select a family member after the user enters the Family_ID.
Is there a way to create a list of values from the multiple fields on another form?
Herb Wexler