Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Copy Value from Item

christm31Nov 2 2012 — edited Nov 8 2012
Hi

I've been asked to create form for someone using Forms 6i.
Basically they wish some data to be duplicated across tabs and tables.
It's a teaching thing so there are 2 tables
1 with an overview of grades
1 with detailed info on grades.

So
Grade_Overview table
Student_Id
Grade_Id
Subject
Score
Teacher Comments

Grade_Detailed table
Student_Id
Grade_Id
Subject
Score
Score_Breakdown
Date of Exam
Detailed Comments
Head Teacher Comments

As you can see a lot of data is duplicated,
They'd like that whenever they input into the tab that looks at Grade_Overview, whichever fields are duplicated in Grade_Detailed get automatically populated in that table and form tab so that when they go into that tab, they only have to complete the missing info.

I thought Copy Value to Item would work but both blocks are multi record blocks to show up to 8 exams at a time and it's only copying the value from the first row of the multi records, rather than them all.

Could anyone advise?

Thanks

Martin
This post has been answered by yoonas on Nov 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2012
Added on Nov 2 2012
20 comments
6,986 views