Update a base using conditions in another base

I have data in one base. and data in another base. Member table, and event table. When i add members, i want the Member id field to automatically show up in the event table based on first name/last name match.