990092 wrote:In general, relation will work. your relation creating was wrong, i think.
I having difficulty in finding solutions to query data from multiple data blocks. By the way I'm using Oracle Forms 10g
I have 4 data blocks and all items are database items
Below are the blocks,
1. student_main (columns : student_id, student_name, student_state)
2. subject_main (columns : subject_id, subject_desc, subject_student_id)
3. invoice_main (columns : invoice_no, invoice_amt, invoice_student_id)
4. receipt_main (columns : receipt_no, receipt_amt, receipt_invoice_ref)
The form will need to allow user to be able to query from any of the items/fields from the data blocks as listed above
: if user query student_id then all related value items from table subject_main, invoice_main, receipt_main need to be displayed
: if user query invoice_no then all related value items from table student_main, subject_main, receipt_main need to be displayed
However the tricky part is that some student might have or might not have invoice / receipt data
I tried using relations but it didn't work both ways
I even create relations in every table (student_main to subject_main, subject_main to student_main, invoice_main to student_main, student_main to invoice_main and etc.) but it just make my running process hang
990092 wrote:i said in general. and it works..
Thanks for replying
I tried creating the relations as advised
It did work where all the item displayed accordingly
However that's only if I tried to query from student_main item (I query student id)
When I test to query using 'subject_id' the value of data block subject_main only appear while the rest didn'tin relation block, query on details block doesn't effect on master block.
Is as if the master block didn't even respond to detail block query