It depends on the project but I lean towards using lots of small tables unless I am really convinced that the number of lookups is going to grow and be simple.
The later did happen on a recent project and the one big table concept worked really well. It allowed for the admins to add lookup fields at will (used for classification stuff that expands all the time). Then cause everything was going off the big table the UI and backend code did not have to be changed one bit to accomodate the extra lookup types. Which in my case meant none of the "Can you add xxx to the form, please" type emails. Which I liked. Cheers, Sam F On 2/8/06, Phillip Senn <[EMAIL PROTECTED]> wrote: > > > > Sam, > > > > On 9/1/2005 I posted a message to > > http://groups.google.com/group/CF_COAL > > that had the code for using sprocs with CRUD screens. At the time I was > using GUIDs for Primary Keys. > > > > I've since gone back to using Identity columns, but you should check out the > post I made back in September. > > A lot of what I posted has been reworked, but that's a good starting point. > > > > ________________________________ > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Sam Shrefler > Sent: Wednesday, February 08, 2006 11:29 AM > To: CFCDev@cfczone.org > Subject: Re: [CFCDev] So many lookup tables, so little time > > > > I would agree on the small tables. Is there a write up about Arf, Reactor, > and all these tools helping with CRUD. I currently write all my own SQL for > the CRUD stuff and am interested in them. Also, how does stored procedures > work with these tools? > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/cfcdev@cfczone.org ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org