Copy Value from Item
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