I'd probably make each issue of the publication it's own ID, and then put that ID in with the kid's ID in your join table (instead of start/stop dates). You'll have more records in your join table, but more accurate data and it'll be easier to then just group by the issue to get the list of kids in that issue.
On 1/12/07, Richard Dillman <[EMAIL PROTECTED]> wrote: > 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:266414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
