Like @AlliAlosa said, you will need to do a lookup. I am guessing you are asking if you can just auto populate the member number by using some formula like Excel. I don’t believe this is possible in Airtable without using lookup—but you can simply ...
