FROM CLAUSE QUERY
Hi Anyone
I am new to using from clause query and am having problems getting data to appear on the from from the query. I have read just about everything i could find on this subject, but nothing is working.
My form has 2 blocks on it.
1st the KEY BLOCK. the key block has 2 fields in it. the term and dept_code. these 2 fields need to be passedused in the FROM CLAUSE QUERY for selection purposes.
The second is the DATA BLOCK, which contains the fields to be displayed. There are 7 fields. STUDENT_ID, STUDENT_NAME, STUDENT_DEGREE STUDENT_MAJR, STUDENT_CONC, ADVISOR_ID, ADVISOR_NAME.
I am new to using from clause query and am having problems getting data to appear on the from from the query. I have read just about everything i could find on this subject, but nothing is working.
My form has 2 blocks on it.
1st the KEY BLOCK. the key block has 2 fields in it. the term and dept_code. these 2 fields need to be passedused in the FROM CLAUSE QUERY for selection purposes.
The second is the DATA BLOCK, which contains the fields to be displayed. There are 7 fields. STUDENT_ID, STUDENT_NAME, STUDENT_DEGREE STUDENT_MAJR, STUDENT_CONC, ADVISOR_ID, ADVISOR_NAME.
0