Hi all, I'm struggling figuring out how to come up with a better plan to connect lots of tables to a large collection.
I have created a collection which has approximately 100 items, each is a profile for an individual athlete. I want each profile to have a separate tables, one for their professional career and one for their college career. Obviously, each individual will have different years and different data, so there will be 200 unique tables.
As far as I can tell, the only way to do this is by creating and connecting 200 other different dataset collections for each unique table. Obviously, this is a huge amount of work and seems needlessly complicated for what I need to achieve. If that's the case, I would rather avoid using dataset collections at all and just make regular pages for each player. But if it can be done more efficiently, I would much rather keep the collection.
My question is if there's a more efficient way to do what I'm trying to do. Ideally, I would only have to create 1 or 2 large collections for all of this data and then somehow ration fields within the 1/2 collections to each player or table, but I don't even know if anything like that is possible.
Thanks in advance