e3digital

I think that would work if the content on page 1 was dynamic, but it will always take the full page. The second page is like an addendum, which note every record will have.

I apologize if I'm in the wrong area... I have a 1-page layout that sometimes is two pages, with a single field on the second page. Is there a way to automate not printing page 2 if the field on that page is empty?

I want to pull info from my Students table into my Enrollments table, simply by starting to type the students name and have the field populate with available possibilities depending on what's entered. (Like a pull down of sorts) So, if I enter an A, I would get Aaron, Adam, Angie, and Ann. If my next letter is n, the list would shorten to Angie and Ann. I've seen this in action, but can't figure out how it was done. Any help would really be appreciated. Thanks in advance... Susan

I've got a relationship set up between Students and Enrollments. I have a layout in the Student table with a portal to Enrollments. The portal is set to show Class, Class URL, and Password. Seems pretty straightforward, but the first record is the only one that shows all the data. All of the records show the Class, none (except the first one) shows the URL, and very few show the password. What could be causing this? Thanks! Susan

I have done a variety of DB solutions, all of which have served the intended purpose. However, I am largely self-taught and know that my structures aren't always the best. I am starting a new solution and would like to do it right from the beginning. Anyone mind offering how you would structure the following: I am tracking student enrollments in online classes. Students from 6 different school districts are taking online classes through my program. The curriculum comes from 3 different vendors. I want to generate a variety of things, including reports based on the courses, the districts, and the vendors. (How many students took Course A?--How many students from District B took a course?--How many students took classes from Vendor C?) I also want to be able to generate class lists for the teachers with contact and login info for their students. So far, I have 6 tables: Districts--name and demographic info for each district Teachers--name, contact info, and licensure areas, and date hired Courses--name and number of the class, vendor, teacher, and number of credits Students--name, ID number, demographic info, DOB, district Enrollments--course name and number, school year, credits, teacher, student name, student username/password for this course Master--no fields currently. I envisioned this being the collection point of all the data....? A student may take more than one course, which may be from different vendors. They will have a different username/password for each vendor, but multiple courses from the same vendor will use the same username/password. I know I have plenty of duplicated fields, but I didn't have time to figure out the right way before I had to print some reports. I have time now,however, and would like to get it right. I hope someone is willing to explain this to me like I'm a third grader--I think in the past I've been making it too hard. thanks in advance. Susan

Thank you... it does exactly what I need. I know my structure could be better, but this work-around saves me tons of time and I don't have to redo the whole project. Hopefully I'll be smarter at the beginning of my next one! Thanks again. Susan

I'm trying to write a calculation that determines, out of 10 fields in linear order, which is the first one to have a valid entry that is not empty. I also need, by the way, to know which is the last one to have a valid entry. Here's the scenario: Fields 1-10, plus First Entry and Last Entry If all the fields are populated, I want First Entry = Field1 and Last Entry = Field10 If only Field10 is empty, I want Last Entry = Field9 If only Field1 and Field2 are empty: First Entry=Field3, Last Entry=Field10 If 1 is empty, 2 is populated, 3 and 4 are empty, 5 is populated, 6 is empty and 7 is populated: First Entry=Field2, Last Entry=Field7 I've been playing around with IsValid and IsEmpty, in a Case function, but can't seem to hit on the right combination. Any ideas? Thanks... Susan

OK... I think I have a better understanding now...thanks so much. S

Ender, Thanks for you help again... how patient are you? : Would the fields in the Tests table go something like this: XYZ Fall K XYZ Fall K Date XYZ Winter K XYZ Winter K Date XYZ Spring K XYZ Spring K Date ABC Fall K ABC Fall K Date ABC Winter K ABC Winter K Date ABC Spring K ABC Spring K Date XYZ Fall 1st XYZ Fall 1st Date XYZ Winter 1st XYZ Winter 1st Date XYZ Spring 1st XYZ Spring 1st Date etc. eventually listing all the tests for all the grades and the dates? I see the value of having all the test scores in the same table, but this seems kind of redundant or something. Also, would I use the same key for all the relationships? Thanks, Susan PS--if you'd like to email me directly, I'm susan "at" e3digital.com

Thanks for the suggestion. I do have all the test scores in one file/table. My structure is like this: A Separate talble for Students, K-Data, First Data, Second Data, ... Sixth Data, Student Records. They are all connected via a Student ID number. Most of the viewing is done in Student Records. There are 7 different tests and 13 test dates. (Some tests are only given once, others twice, and a few 3 times.) If I were to redo my structure, what would it look like? Also, when you say sort by Date, are you suggesting a date field for when the data is entered, or some other date? Thanks again... Susan

I'm working on a solution that tracks student scores on various tests across 6 years. I want to get the current gain for a given test and am having trouble with the calculation. Here's the scenario: The XYZ Reading Test is given in the Fall, Winter, and Spring of each grade, from K through 6th grade. I want the "XYZ Reading Gain" field to display the student's gain on that test at the present time. For example, if the student has been enrolled since Kindergarten and is now in 4th grade, I want the gain to show her most recent XYZ Reading score (Fall of 4th grade), minus her first XYZ Reading score (Fall of Kindergarten). I know the basic formula is XYZ Recent Score - XYZ First Score (these are not fields) The catch, of course, is that not every student has been enrolled since Kindergarten, and the most recent test isn't always Fall. How do I account for those variables and get the accurate Gain? Thanks for your help... Susan

Thanks for the script... it worked like a charm. And taught me about the Length function :-) Susan

Thank you for your feedback... I agree that the structure is not good. I inherited it and haven't had the time or green light to modify it. In the meantime, there were some extra characters (spaces and carriage returns, mostly) that seemed to be causing some problems. I removed them and haven't heard from the client since. When my current project ends I am going to lobby for a new structure and learn more about join files. Thanks again, Susan

I have a solution with about 1800 records in it. I have just recently added a validation to 10 of the fields so that they can each have only 8 characters. Is there a way I can go through the existing records and find/remove the extra characters that were there before I created the validation? Does the Trim function do this? Thanks. Susan

I'm running a script that compares the "looking for" data (a teacher's name) to 10 different fields in a record, and, via a loop, across all the records. When the appropriate records are found, it displays some related data for the found teacher. Until recently I believe it has been working correctly. Lately, however, it's been naughty! :-) The script itself runs without error, but when it displays the data, it sometimes shows the wrong info. A little more background...Each record is a student in Special Ed. Each student can have up to 10 different teachers working with him/her. For each teacher, we list the amount of Direct Time and Indirect Time spent with the child (for state reporting and billing purposes). The script first asks the user to enter in a global field the name of the teacher they are looking for. It then compares the global field to the fields "teacher1", "teacher2", "teacher3", etc to find the students that teacher services. Once the students are found, it displays the student name as well as the "DirectTime" and "IndirectTime". The problem is, it's not always pulling the correct time. For example, Teacher B sees Student Z for 40 minutes. In the display after the script is run, it might display 90 minutes, which is the correct time for Teacher A. The data is not changing...on the Data Entry layout Teacher B is still listed for 40 minutes. The next time we run the script, it might be correct. It seems to be totally random--sometimes it works, sometimes not. Sometimes it displays the time for Teacher A, others for Teacher D. The student, teacher, school, times, ... none of it seems to be consistent as to when it works. It was running across a network using FMServer on a Mac G3 server. Yesterday we moved it to a PC server (don't know the OS), but today we're still getting problems. I would sleep so much better if someone had a clue about what I could try. Thanks, Susan