Potentially you could by the sound of it, but will probably need to know a little bit more about how you’re thinking of setting this up.
Why not give it a go first and see where you get to, and then come back and get support if it doesn’t work out as you thought it would.
Certainly review the video tutorials on secondary tables to really understand the formula techniques you need to utilise if this is the road you want to go down.
Sam