Hello Community,
I want to make an editable grid with fields having below details
Column Names - studentCountry , studentName, subject , status - (Pass or Fail)I've Created the grid where the studentName will be repeating and read only because of the different subjects & also subject will be read only-> the user (teacher) should fill the studentCountry and his status - (Pass or Fail) in editable grid,Now my requirement is such that when a teacher selects student country for a particular student it should update the studentCountry for all the rows having that particular student name.How should I achieve this. Any suggestion will helpful.Some sample data for better understanding studentCountry studentName subject status1) dropdown Student A Maths Yes/No (radio button)2) dropdown Student A Science Yes/No (radio button) 3) dropdown Student A English Yes/No (radio button)
4) dropdown Student B Maths Yes/No (radio button)5) dropdown Student B Science Yes/No (radio button) 6) dropdown Student B English Yes/No (radio button)
Thanks in advance.
Discussion posts and replies are publicly visible
There are various potential approaches to this, but choosing which approach really kinda depends on the structure of your CDT and how you're using it in your interface. For example.. is the "student country" data really duplicated across every row of student/subject data? Or is it kept separate somewhere (i.e. just relative to a single Student entry)?
Thank you Mike for the quick reply,
well this ain't my actual scenario but justifies what I want to do with the grid,So in my actual use case I am using view which is formed using two tables as the data for editable grid,
So based on that for above data you can say studentCountry and studentName will be kept unique in "student data" table and the subject & status will be coming from some another table "subject status" table"student data" table is going to have one to many relationship with "subject status" table.Thanks in advance.