One Contact, Multiple Roles, Different Status Per Role

Split your users as Active and Inactive status. and each status can have many titles (example fosterer, trainer, , volunteer, subscriber.." 

if your business structure is that you reset at a specific time (example annually), you can create a tick field for the years & one for status (or multiselect) & then create a view for your year- this helps for me to choose the perks per year (example last year we gave perk X but this is not valid for this year, without losing the perk data)

Hi @ScottWorld , Many many thanks for your advise above. I have restructured my base to accommodate your suggestions and all the linked records are working perfectly. However, it only works 'backwards'. By that I mean, if I create a new contact in my master People list and use the newly created linked field to select what kind of contact/contacts they are ie. Mrs Y is a 'Fundraiser' and also a 'Volunteer' - it does not create invidual records in my junction table where I am able to select their status - ie active/inactive/potential etc etc. But, it would be really cool if in my new human form i can actually select the various types of contacts and what their status is respectively but I can only do that in my junction table AFTER a new human has been created. x

You’re welcome!

If you’re doing the data entry from within Airtable as a logged in user, you can create brand new records in other tables without leaving the existing table that you’re working in.

However, if you’re doing data entry using a form, Airtable won’t let you add new records in other tables through a form. One workaround for this is to use Fillout’s advanced forms for Airtable, which not only gives you this capability, but also gives you about 100 other advanced capabilities that Airtable’s native forms don’t offer. It’s free, too!

Hi @ScottWorld , you are incredibly helpful.
One last thing - I am tyring to transpose my Linked Record with Multiple Humans in one cell to individual rows/records in a new table... I know there's lots of scripts flying around but none seem to work for my fields (very very very sad and frustrated face!!).
This is what I have
Primary Field                    Linked Records Field/Cell
Volunteer                           Mr X      Mrs Y    Ms Z
Supporter                          Mr X      Ms Z

I need it to be turned into a new table thus:
Primary Field                     Type
Mr X                                   Volunteer
Mr X                                   Supporter
Ms Z                                   Volunteer
Ms Z                                   Supporter
Mrs Y                                  Volunteer

The junction assistant extension that @Kamille_Parks11 created might be able to help you do that quickly.

Thank you @ScottWorld , however I managed to create them through an automation using the repeat for each group in option. 🙂