I have a many to many bridge table which contains some extra fields other the the pks of the two parent tables. How can I update this table using AR records?
My table structure has the following columns,
categoryid (fk from category table)
productid (fk from product table)
otherfield1
otherfield2
As this is a many to many bridge table, categoryid and productid are the composite primary key. Otherfields* are some extra information i need to store.
Is there any way I can handle this with AR records? or any extensions?