Opens an existing record in the 2nd table or creates a new record?
Are the tables linked in a relationship?
If so, please describe that relationship.
I'd like to open an existing record in the 2nd table.
I established a relationship between the two identically named fields in the two tables. I didn't qualify the relationship in any way. In the second table, the field's value will only exist once, whereas in table one, it will exist multiple times. (this is a breeding database, table two has the parents, table one the offspring)
If you are creating a new record in the table on the "many" side of the relaitonship, you can use Go to Related records to change layouts and bring up the matching parent record.