Patti, I think Bill_D is giving you good advice - it's a bad habit of his! - and that's more or less where I was headed, too. I have some background in survey-based research and, if you would like, I might be able to share a couple ideas from that experience that intersect with what Bill is sharing. I just don't have that content with me right now. It's on another disk, at home. I'll find it this evening and fwd that to you. Steve
________________________________ From: [email protected] on behalf of Bill Downall Sent: Tue 6/7/2011 1:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: need Array logic Patti, It's not difficult to create a view, temporary table, or report from a properly-normalized "narrow" table that puts the data into the wide format that your correspondents require. People here will help you get going, and you'll have a system that is much more efficient to maintain when things change, down the road, as they always do. Bill On Tue, Jun 7, 2011 at 2:22 PM, Patti Jakusz <[email protected]> wrote: thought about doing the "narrow" table as you suggested (kind of a cross between your two methods), but I will have to build a "wide" table anyway, for sending data to other health depts. I was hoping to only have the wide one - but maybe it will be easier to have it both ways.
