Making a query in Forms 6i to insert values
Hi everyone,
I have 2 Data Blocks in Forms 6i, one is not a Database Data Block and the other one is.
In my first Data Block I have 3 items: teacher_id, grade and class_id
Then, the second Data Block has 10 items where I'm going to be showing 10 rows of data
from my database when the user types the credentials on my 3 items that belongs to my first
Data Block.
Seconda Data Block items:
student_id, student_name,grade_q1,grade_q2,grade_q3
The form should be able to bring just the student_id and the student_name. I have to type then
grade_q1, grade_q2, etc. After that I have to add a buttom to insert all the new information that
I typed to the database.
My question is:
How can I make Forms 6i bring all the data that belongs to that teacher_id, grade and class_id?
After that I would like to insert some data and insert them in the same form.
Can anyone please help me!