I would agree with Deanna. That is a necessary step, but then I would suggest normalizing one step further.
tbl_Children (childID, ...) tbl_Periodical (periodicalID, ...) tbl_PriodicalIssue (periodicalIssueID, month, year, periodicalID) tbl_PeriodicalChild (periodicalChildID, childID, periodicalIssueID) You want to avoid duplicate information about a Periodical, so you create a table that keeps track of every issue that has been published. Now you have a table that will avoid duplicates of periodicals and children. Teddy On 1/12/07, Deanna Schneider <[EMAIL PROTECTED]> wrote: > > 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:266419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
