I have a table of kids [tbl_Children] ID (integer PK) Firstname (varchar 50)
I have a talbe of periodicals and how often they publish [publications] ID (integer PK) Distribution (integer) (simpy weather or not they publish monthly or quarterly) Title (varchar 50) I have a table of kids to periodicals [features] ID (integer PK) Child (integer) Pub (integer) StartPub (Date) StopPub (Date) This is where it gets hard. A child could be in say the adoption monthly from01/01/2006 - 03/01/2006 then they are pulled while they intervie with a family or 2.... things dont work out we put them back in. 06/01/2006 - 12/01/2006 Text wise its easy to display, but what if im doing a grid of Adoption Monthly 2006 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec no problem looping through the first series of dates but not sure how to go about getting the second series on the same row. Or am i going about storing the dates wrong? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 "If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else." -- Chinese proverb -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
