Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Multiple Roles Expressed in Linked Field

Topic Labels: Base design
Solved
Jump to Solution
558 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Samuel_Duncan
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
Samuel_Duncan
5 - Automation Enthusiast
5 - Automation Enthusiast

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

See Solution in Thread

1 Reply 1
Samuel_Duncan
5 - Automation Enthusiast
5 - Automation Enthusiast

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