edudna Posted November 28, 2006 Share Posted November 28, 2006 I have just to ask if there is a way to create automatically fields depending on a list values. Explain further: To create a layout with fields depending on a list values. Pascal Link to comment Share on other sites More sharing options...
Genx Posted November 28, 2006 Share Posted November 28, 2006 Maybe not necessarily "Creating" a new layout, but there may be a way to do what you want using GetField(). Please expand on your question. Link to comment Share on other sites More sharing options...
edudna Posted November 28, 2006 Author Share Posted November 28, 2006 I have attached a file to see what I want to do. List values from the first table become fields in the second table with the same names. But it is only the idea I do not know how it can be in reality... Pascal Experiment.zip Link to comment Share on other sites More sharing options...
Genx Posted November 28, 2006 Share Posted November 28, 2006 From the looks of your example yes, but... You want to for example select 4 of 20 subjects and view what about them? I need more of a sample "view" of what your after -- and also some sample data. Link to comment Share on other sites More sharing options...
edudna Posted November 28, 2006 Author Share Posted November 28, 2006 Thank you again for your reply. It is a problem that I can not solve and I have stop my project for 15 days now... I have to show in a layout or portal the grades of students in all the classes that they have. So we have a list with classes, that a student takes for a period or a year and this list is created from the records of the classes table. But this is not enough to show all the classes and all the students at once in one layout or a portal. Because classes must be in fields not in a list to be show correctly. So we need to convert the list of classes to fields automatically. I hope you understand... If you do not I prepare an example for this. But it is complicated anyway. Pascal Link to comment Share on other sites More sharing options...
Genx Posted November 28, 2006 Share Posted November 28, 2006 Yeh sorry, It's not coming together in my head very well I will need an example if you can. Link to comment Share on other sites More sharing options...
T-Square Posted November 29, 2006 Share Posted November 29, 2006 I haven't looked at your sample file, but if you have tables for: Students Courses Enrollments (join table between Students and Courses) you could easily display the courses a student has taken by using a portal of the Enrollments table. This portal would not have to display the entire course offering--just the courses that each student has enrolled for. This Enrollments table could include a field for the student's final grade, which would be displayed on the portal. If you want to take it down the road further, you could set up an Assignments table that would be associated to the Courses table and a EnrolleeAssignment table that joins the assignment to the enrollee, store the assignment grades in that table, build some summary fields to calculate a student's overall grade for a class, and your teachers can keep their gradebooks in your system. You'd have to script an Add Assignment button to autopopulate the individual enrollee records for each assignment, but that's not too horrible... My head spins with the possibilities! David Link to comment Share on other sites More sharing options...
Genx Posted November 29, 2006 Share Posted November 29, 2006 I'm not exactly sure that's the issue (but then again, i could be very wrong). I've been going mainly off the topic title for context. Link to comment Share on other sites More sharing options...
edudna Posted November 29, 2006 Author Share Posted November 29, 2006 Let me explain a little more... The table with students and the table with courses as it is show in the relationships panel has already been one to many. So what need the enrollments table anyway? I am confused... Link to comment Share on other sites More sharing options...
Genx Posted November 29, 2006 Share Posted November 29, 2006 I don't know... do you want to show all the students for a course that you select from the top? i.e. you select History, Maths and science and you get the following HISTORY............MATHS...............SCIENCE John Williams......Brian Mathews.......Elga Jordan Henry Ectar........Lord Brian Thomas...Frank Kronos Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6348 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now