Autofill from another record based on field data
I have two tables in my database, one with People information that includes a gender field, and another table for Married couples that has a unique ID for each married couple, along with fields for the Male and Female in this marriage. I have these databases related by this unique ID, but what I would like is to simply enter the Marriage ID in these databases, and then with this link have the database look up the appropriate gender to place in the respective "Male" and "Female" fields. Is this possible to do? I cannot find a way to have FileMaker perform this, either as a search, or as a lookup routine.