search for: orders_item

...to an issue over join tables. I am reading Agile Web Development and it says that I can put additional fields within my join tables, and they give the example of a date field. I want to know if it is possible to do the following: I have an orders table with the order information as well as an orders_items table and an items table It is a habtm relationship. I need to be able to update the item information for the specific order without changing it in the items table (ie. the items table holds the default values for the item, and the orders_items table holds the updated values, such as price, an...