Hi Lester Caine,

> I am not quite sure what you are trying to do - which makes helping
> difficult. Something like
>
> QSG_NAME
> QST_NAME, FRM_ID
> QST_NAME, FRM_ID
> QST_NAME, FRM_ID
> QST_NAME, FRM_ID
> QSG_NAME
> QST_NAME, FRM_ID
> QST_NAME, FRM_ID

No! I try to explain again :-)
I have eg. 3 groups (1,"Group_1"; 2,"Group_2"; 3,"Group_3") in the tblQuesGroup.
Addition I have eg. 40 questions (1,1,"1_Question_of_1_group";
2,1,"2_Question_of_1_group"; 3,2,"3_Question_of_2_group";
40,3,"40_Question_of_3_group"; etc.) in the tblQuestions.

When the user process a new questionnaire (insert tblForm), in this case
I have to show all (1..40) the questions in the screen in order to the user
can fill his answers in (tblForm.FRM_POINTS := ?).

When the user has already processed the questionnaires I have to send the
records to the server and commit the transaction.
eg.: INSERT INTO tblForm (QST_ID, FRM_POINTS) VALUES (1, ?);
INSERT INTO tblForm (QST_ID, FRM_POINTS) VALUES (2, ?);
...
INSERT INTO tblForm (QST_ID, FRM_POINTS) VALUES (40, ?);

What kind of TIB_xxx control can help me to show the questions?
My idea was to fetch all the records from the tblQuestions to the MemoryTable

eg.: SELECT tblQuestions.QST_ID
, tblQuestions.QSG_ID
, tblQuesGroup.QSG_NAME
, tblQuestions.QST_NAME
FROM tblQuestions
LEFT JOIN tblQuesGroup
ON tblQuestions.QSG_ID = tblQuesGroup.QSG_ID

and show into a TreeView which can be edited by the user (only the answers can be edited).

|- Group_1
|- 1_Question_of_1_group <TEdit>
|- 2_Question_of_1_group <TEdit>
|- ...
|- Group_2
|- 3_Question_of_2_group <TEdit>
|- ...
|- Group_3
|- ...
|- 40_Question_of_3_group <TEdit>

> make your tree in the grid, with check boxes to open and close a group

Which component can do this? AFAIK, the TIB_Grid can't do this.

Regards,
Norbert