I'm thinking that you don't even need the DayOfTheWeek table, especially if all it contains is an ID related to a Day of the Week (1, Monday|2, Tuesday, etc.) Depending on what you're trying to do, you may not even need the WeekOf table.
How are you joining the tables? Send us the query. You might also look into the Week([date]) and DayOfWeek([date]) and DayOfWeekAsString([1-7]) functions in the documentation. Sharon > I need to show a page that returns a table of IDs sorted by a WeekOf ID - > showing the most recent. > > Within that result set there needs to be details corresponding to those IDs. > [so far that works]. > > The problem is, how can I return the details sorted by DayOfWeek and show > multiple sets of details for > > the same DayOfTheWeek ID. > > As of now I have; > > History Table [shows the ID of the records I want to return] > > 4 detail Tables [Each has a Descriptions and an ID to the name of the day of > the week] JOINED to the > > DayOfTheWeek Table [1 = Monday] > > a WeekOf Table [numbering the weeks of the year] > > > > > > > _________________________________________________________ > > Do You Yahoo!? > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists