Fecth data from a table in to grid view and save it to another table

[alazarbaharu]

Hello guys previously I posted this question in MSDN and all of the suggested solutions didn’t work for me and now I am bringing my question back to this forum. My question is
I have two tables
Residency with four attributes
• name
• id
• locationid
• sex
Education table with five attributes
• name
• id
• location
• sex
• educational_level
I have a form and inside that form there is a textbox where users will be allowed to input locationid and based on the input data the grid view on the form will be populated by the data from the residency table at this time the column educational_level will be empty on the grid view. Then I will insert some data on the educational_level column on the grid view. If I click the save button on the form I want this grids data to be saved on the education table permanently. So how can I do this?
Thank you for your kind support…

 

[JRB-Bldr]

I am not sure I fully understand your Form.
You have one Grid showing Residency table records (or a sub-set thereof based on the input data 'locationid')

the grid view on the form will be populated by the data from the residency table at this time

insert some data on the educational_level column on the grid view.

But if your Grid is showing records from Residency, where is the column educational_level (note - too many characters for most field names) coming from - since it is not in the Residency table.

Regardless, when you click the Save button, you can readily run a Query of the data showing in the Grid and have it go into a READWRITE CURSOR based on your desired selection criteria.

Then, if you can Append the Cursor records into Education table.

Good Luck,
JRB-Bldr

 

[alazarbaharu]

Hello Sir Thanks for your reply, let me clarify my question just like this
I have two tables residency and educational
Also i have two forms form1 and form2
inside form1 i will have textbox for users to input locationid and based on the locationid data will be populated on the form1 grid1 from residency table and when i click a button the data will be transferred from from1 to from2 and the populated data on grid1 will be populated to grid2 which is available inside form2 and i want to modify the data on grid 2 and finally save the data on button click to the educational table. That is what i want, Thank You