Greetings,
I'm fighting with a poorly designed SQL Server database. The database is not normalized whatsoever, so I'm running into some brick walls trying to get Rails to be friendly with it.
I need to create a habtm relationship between a User table I created and a Depletion model I created. Depletion points to a view in the database called "Dep" that has no primary key. It has a varchar-based column called "VendorNumber" that I want to use to populate Depletion side of the relationship. In the end, the user should be able to view the records for many Depletion vendors.
Is there a way to manually populate the join table to store the user id and the string-based vendornumber and still use some of the niceties afforded by the habtm relationship?
Thanks.