P.S. Thank you guys, Skip and PHV. I actually did a little of both of your ideas. I used a DO...WHILE loop, that made use of 2 recordsets, a source and destination. Thanks to both of you guys for your ideas and input! Thread closed!
For testing I just made a simple form with a button that executes an SQL query. The finished product is going to be an Active Server Page, and I think that's why it needs to be flat. Honestly, I don't know anything about ASP, but my boss does. He was saying that the ASP can only work from 1...
Correct. I'm in Indiana, PA actually. However, Colonial is not one of the districts that we service. I work for an Intermediate Unit actually, which is probably why you got mislead when you heard things like ASSIGNMENT. Basically, we help with special-needs kids. So an ASSIGNMENT in this...
Dude! *slaps-self-in-face* I think that's it!
DIM PrevID
DO WHILE PrevID = StudentID
PrevID = rst("StudentID")
...
...
rst.mocrnext
I might have to buy you a drink Skip! I been staring at this nightmare for so long that I'm overlooking the little things, like DO WHILE loops!
Skip, just so you know, the consultants who made this monster charge $125 per hour. While me? I make a lowly $20. SO naturally, they want me to bang MY head against the wall over it. The problem is that if I was as good as the consultants at code and whatnot, I'd just quit and charge $100 :)
Andy is right. Each ASSIGNMENT has many fields to it. Each assignment has an ASSIGNMENTID, so I would need 3 ASSIGNMENTID fields. Each assignment has a STARTDATE and STOPDATE, so I would need 3 STARTDATES and STOPDATES.
I would just use MOVENEXT to get to the 2nd ID and STARTDATE and...
Andy, I'm looking to use only the top 3 assignments. No student has more than 3. However, there are up to 10 related-services. Yes, I was going to have to put up to 3 assignment fields and 10 services fields. It stinks.
It's Tek-Tips,not Tek-We-Give-You-Attitude. If you can't help, that's fine. Thank you for viewing the post and giving it some brain-power. I genuinely appreciate it, as my own brain-power just isn't cutting it.
The entities are already related. I'm not asking for help with relating...
No... you don't understand the relationships. I've been working with this databse for a year now and I don't even understand them all. The EMPLOYEE table contains information for teachers, psychologists, physical therapists, and other staff needed for the students. Each student's ASSIGNMENT...
Keep in mind, I don't need to turn all of those tables into a flat database. Those are just the tables that contain the data that I need. I have put together about 4 queries that extract the data needed. However, some of it is 1-to-1 and some of it is 1-to-many. So I can't use a simple...
Yeah, making a flat table that emcompasses the data needed for 1 student's general information needs about 75 fields to be available. Give or take, since some students have more assignments and services than others. It's a huge headache, and I'm having trouble conveying this to the head honcho.
Here's a few of them. These are probably the most important for tracking purposes:
ADDRESSES, ADDRESSTYPES, ANTICIPATEDSERVICES, APSASSIGNMENTS, ASSESSMENTSANDACCOMODATIONS, ASSIGNMENTS, AVAILABLEASSESSMENTS, BUILDINGTYPES, CASELOADSTUDENTLIST, CHARTERASSIGNMENTS, CLASSROOMS, DAILYATTENDANCE...
Well, currently the tables are joined. There's over 100 tables actually and most of them are joined. The problem is that we want to take select records, move them to a server that we can make available to the Internet, and create a front end that schools can access to update student...
I'm trying (unsuccessfully) to put together code that will basically turn a '1-to-many' database and convert it into a flat database. Here are the basics:
A query is run that will find all of the students within a particular school district, and put them into a table. The unique identifier is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.