Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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!
  2. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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...
  3. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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...
  4. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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!
  5. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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 :)
  6. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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...
  7. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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.
  8. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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...
  9. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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...
  10. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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...
  11. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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.
  12. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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...
  13. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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...
  14. lmccroskey

    Turn 1-to-many tables into 1 huge flat table.

    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...

Part and Inventory Search

Back
Top