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

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Ddc850a63a423c3ff963bdf3a097652f?d=identicon&s=25 Larry Kelly (ldk2005)
on 2006-06-01 16:30
(Received via mailing list)
I'm working on an application where several customers will be using the
same
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
also
don't want to make building the drop-lists any harder than they need to
be.
I have thought of two ways to do this.  I'd appreciate feedback and
comments
as to which method might be better .

1. Break normalization rules by putting the customer_id in every
drop-list
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
necessary
joins to populate the drop-lists for each customer_id.

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