Reply to thread

Message: [QUOTE="Jeff Boyce, post: 4991726"] Wayne Just as you've found the size of your task somewhat daunting, it's a bit tough to get a handle on where to start, given the size of your post. Is there a chance you can focus in on a single aspect and re-post? I would agree that the place to start is in normalizing your data structure. And I agree that 100+ fields is too many for a single table! Have you stepped away from the computer and used paper/pencil to draw out your entities and relationships? This is a crucial first step. After that, I'd look to find homes for all the attributes. Finally, I'd ask myself about what queries/reports I wanted, and make sure that the required underlying data was in my earlier work. THEN, I'd start building tables <g>! [/QUOTE]