[RESOLVED] Dummy datagrid?

[ejpotpot]

Hi,

I am not sure if I made correctly the right thread title but I have these tasks to do with the following specifications:

1. The user has to input Group No. say "01" in a text box provided during Add routine;

2. I have to read a table named Group for all records having the group no. = "01" entered by the user in item # 1;

3. Here's the challenging task for me . I have to display a dummy datagrid filling an initial two columns corresponding to the number of records fetch from a group table with group no = "01", , plus additional one column which the user has to complete entries under the rating column as shown below;

Grp Id Lastname Rating
01 Young
01 De vera
01 Villoria

4. Another task left for me, the completed entries in the dummy datagrid will have to be saved to a table named Detailed.


Thank you in advance for your inputs.

[kenchix1]

Suggestion:

Create a dummy table where you can insert data with the condition using your textbox value. something like:

cn.execute "insert into dummytable select field1,field2 from Group where groupid='" & text1.text "'"

when the data is inserted use it as the recordsource of the datagrid. Now, you'll be using the dummytable while the user edit the data.

after the user input, on the save button execute another query that will insert the data from dummytable to Detail table.

cn.execute "insert into detail select * from group"

then delete all records at dummytable

cn.execute "delete * from dummytable"

*I didn't test the SQL statement here, what I point out is the logic.

HTH.

[ejpotpot]

Suggestion:

Create a dummy table where you can insert data with the condition using your textbox value. something like:

cn.execute "insert into dummytable select field1,field2 from Group where groupid='" & text1.text "'"
when the data is inserted use it as the recordsource of the datagrid. Now, you'll be using the dummytable while the user edit the data.

after the user input, on the save button execute another query that will insert the data from dummytable to Detail table.

cn.execute "insert into detail select * from group"

then delete all records at dummytable

cn.execute "delete * from dummytable"

*I didn't test the SQL statement here, what I point out is the logic.

HTH.

Thanks kenchix1 for valuable inputs.