Forum: Ruby on Rails OT: Best practice for multi-user select boxes

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Larry K. (Guest)
on 2006-06-01 18:30
(Received via mailing list)
I'm working on an application where several customers will be using the
database.  I want them to be able to build their own entries for various
drop-down lists is if they were the only user of the application.  I
don't want to make building the drop-lists any harder than they need to
I have thought of two ways to do this.  I'd appreciate feedback and
as to which method might be better .

1. Break normalization rules by putting the customer_id in every
table. This would make it easier to create  the droplists using the
'acts_as_dropdown' plugin.

2. Keep the table fully normalized.  Use find_by_sql to create the
joins to populate the drop-lists for each customer_id.

3.  Something else entirely.
This topic is locked and can not be replied to.