Radicore Forum: Application Development » 2 Grandparents, 2 Parents and 1 Child table

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)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

2 Grandparents, 2 Parents and 1 Child table [message #3812]

Wed, 31 July 2013 10:35

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:

I want to start with a screen that lists academicsession records (AcademicSession: LIST1)
I want to place a navigation button that reads "Manage Courses" that lists courses associated with the academicsession (Courses: LIST2)
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)
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)

Report message to a moderator

[Message index]

		2 Grandparents, 2 Parents and 1 Child table By: haider.faraz on Wed, 31 July 2013 10:35
		CORRECTION: 2 Grandparents, 2 Parents and 1 Child table By: haider.faraz on Thu, 01 August 2013 00:05
		UPDATE: 2 Grandparents, 2 Parents and 1 Child table By: haider.faraz on Fri, 02 August 2013 05:38

Previous Topic:	Button on a detail record of a list transaction pattern
Next Topic:	New window for graphics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

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

Total time taken to generate the page: 0.01499 seconds