AnsweredAssumed Answered

Lookup Data from same table, but a different record

Question asked by chf on Apr 3, 2015
Latest reply on Apr 9, 2015 by philmodjunk


Lookup Data from same table, but a different record


I have a database, for animal husbandry, and each record has a unique ID.  Within each record in the "inventory" table, there are fields that show that animal's unique ID, it's name, and the parent information.  This includes the unique ID for both the father and the mother (both of which are also in this database), and then the father and mother's name.  Is there any way to make it so that when I enter the father's unique ID into the "father ID number" field, it automatically populates the "father name" field by finding the father's record, and populating it with the "Name" field that is listed for that record?  I know you can set the field as a lookup field, but you can only look up items from other tables.  This is information that would be within the same table.


Thank you for your help,