Craig White wrote: > I would have a table called pricing and have a column that had the > customer_id and thus you might have 2 (or more) prices for an item but > only one for a specific customer or default to the one that is not tied > to a specific customer.
Hi Craig! I don't think this would work as there are quite a number of clients (over 25) who currently have a different price per product. In the future there might be additional clients with custom pricing depending on how much volume they push. If I were to implement your suggestion I would have to have 25+ fields (pricing_1, pricing_2, pricing_3, etc.) which I don't think is the correct approach for this. Did I misunderstand your suggestion? Thanks again, -Tony -- 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 rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.