Multiple Roles Expressed in Linked Field

[Samuel_Duncan]

Hi all,

I am building a base for capturing information about a large collection of school trophies. The "trophies" table includes a linked field, "people." In the "people" table, there is a "role" field. There may be cases where a person has multiple roles, e.g. "alternate" and "student." It seems like there should be a way to characterize the relationship from trophy to person by multiple roles. I don't have enough experience to know my options. Can someone help?

https://airtable.com/shruKrwtvk0k9OEFv

Also, is there a way to limit a date field to year only?

Thanks mucho!
Sam

[Samuel_Duncan · Accepted solution]

Never mind, I forgot about junction tables. I think I have it worked out.