Supplying some further information:

Each table currently does not have a team_id - they each only have their 
regular IDs.

Secondly, I parse data weekly so there are multiple week snapshops of 
each table.. for example:

Week 1 Snapshot houses 120 teams and their data (non-ordered) ids from 
1-120.
Week 2 Snapshot houses the same 120 teams and their new data 
(non-ordered) ids range from 121-240.
Week 3 Snapshot houses the same 120 teams and their new data 
(non-ordered) ids
range from 121-240.
etc.
etc.

This applies to every table I have.  In my model I currently show the 
current week's data only.  I could simply overwrite this data, but I'm 
saving weekly snapshots so that people can select previous week data or 
data from farther back.

So, there needs o be an associative team_id that is assigned to every 
team and so it's the same for every table.. i.e. 120 teams in 
alphabetical order with team_ids that range from 1-120.  This should 
apply to each table.

How do I create the join table to accomplish this?

Thanks.

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to