Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Application Development » 2 Grandparents, 2 Parents and 1 Child table (How best to copy data from multiple parent tables to a child table)
2 Grandparents, 2 Parents and 1 Child table [message #3812] Wed, 31 July 2013 10:35 Go to previous message
haider.faraz is currently offline  haider.faraz
Messages: 15
Registered: July 2013
Junior Member
The tables:
1 child table: courses
2 grandparent tables: planofstudies, templatecourses → create 1 parent table: planofstudycourses
2nd parent table: academicsessions

The schema of the tables is attached.

I want to create a record in the courses table. But I want to do that as follows:
  1. I want to start with a screen that lists academicsession records (AcademicSession: LIST1)
  2. I want to place a navigation button that reads "Manage Courses" that lists courses associated with the academicsession (Courses: LIST2)
  3. On the screen from step (b) I want to place a button that reads "Add Course" that lists all records from the planofstudycourses table along with extra fields fetched from the corresponding records from the planofstudies table and the templatecourses table (Planofstudycourses: LIST1)
  4. I want to place a navigation button on the screen from step (c) that reads "Add Course". When this button is pressed I want to:
  • Present a record from the courses table on the screen with data populated from the academicsession table from screen (a), planofstudies table and templatecourses table via the link table planofstudycourses from screen (c).
  • I then want to enter data for the fields course_class_and_section and teacherid via a textbox
  • On pressing the submit button I want to return to the screen in step (b).

I got as far as step (c) but I don't know how to complete step (d). How would you advice?
  • Attachment: schema.pdf
    (Size: 21.83KB, Downloaded 895 times)
Read Message
Read Message
Read Message
Previous Topic: Button on a detail record of a list transaction pattern
Next Topic: New window for graphics
Goto Forum:

Current Time: Tue Jun 28 14:11:38 EDT 2022

Total time taken to generate the page: 0.01499 seconds