Loading Different Lists Based On Cell Value In XtraGrid

See more:

VB

DevExpress

Hi guys

I have two Xtragrid controls on two different forms, one is bound to the dataset and the other is not, Basically what needs to happen is this.....

First Xtragrid contains values such as

ID = TextEdit
EventID = TextEdit
Questions = TextEdit
Answers = TextEdit
Used = CheckedBox

Each of the questions are different and they can have a max of 6 answers so it looks like this

ID EventID Questions Answers Used
1 DEMO 1 A (CheckBox) = Checked
2 DEMO 1 B (CheckBox) = Checked
3 DEMO 2 C (CheckBox) = Not Checked
4 DEMO 2 D (CheckBox) = Checked

In the above example both questions 1 and 2 are the same question but with different answers Question 1 could be answerd with A or B subject to them both being checked,
and the same goes for question 2

This part i have nailed to a T

But based on the Checked column it should only load the the first, second and forth row in the second Xtragrid

What I require next is to have the second Xtragrid control which is bound to nothing yet to look like this

Questions Answers
1 (RepositoryItemCheckedComboboxEdit) = With a possible answer A or B ( or A and B)
2 (RepositoryItemCheckedComboboxEdit) = With only D as a possible answer

I hope you could understand my question if not I will try to re-explain it.

Well thanks in advance and looking forward to getting a solution quickly.