Search options (Page 7 of 10)

Thank you ehwagner. It is really good solution which I wanted but it created confusion. Confusion is from where a.sdate, b.sdate, b.id_Category , sales a, sales b fields come? No in any table?

on click save button?

Thank you brain

Thank you Brain. I got an idea. Would you to tell how to get print.

Thank you brain to reply. I did what you have typed but still error. I am attaching your project look at it. Second I am attaching a pic. There is one date 9/10/2020 but result is showing separate result four time not one. I want to get the result in one time. How it will be? Obviously on this date in class one 6 students were present. So under Present heading it must be 6 not 3,1,1,1. I am sure you will understand what I want.

Thank you Brain
Would you like to tell how did you create relationship field? id_student  because I am getting error message?

Thank you CDB. It works.

Thank you CAN To solve my problem

Thank you ehwagner and brain.zaballa.
I used following statement which had given my desired result.
Tsales.TableGrid1.dbSQL:= 'SELECT `sdate` "Date",`name` "Costumer",`sitem` "Cold Drink",`svalue` "Price" FROM `sales` where sales.id_Category=6 ';
Tsales.TableGrid1.dbSQLExecute;

This statement worked very well but my problem which need to solve. I want to get more sales.id_Category= 6 , sales.id_Category= 2, sales.id_Category= 8  etc, etc
How will I type statement?
Secondly, I can I get other field of other table in same same statement.
Thank you all in advance.