Real time Java script calculation for update Row & column total

[Barand]

In that case...

 +------------+
 | category   |
 +------------+
 | id         |------------+
 | cat_name   |            |
 +------------+            |
                           |
 +---------------+         |
 | subcategory   |         |
 +---------------+         |
 | id            |------+  |
 | category_id   |      |  |
 | subcat_name   |      |  |
 +---------------+      |  |
                        |  |
                        |  |
                        |  |    +------------+
                        |  |    | model      |
                        |  |    +------------+
                        |  |    | id         |
                        |  |    | model_name |
                        |  +---<| category_id|
                        +------<| subcat_id  |
                   +-----------<| brand_id   |
                   |            +------------+
                   |
 +------------+    |                             
 | brand      |    |                             
 +------------+    |                             
 | id         |----+                             
 | brand_name |                                  
 +------------+  

 

[Senthilkumar]

yes correct

[Barand]

Now you need to determine the relationships (if any) between model/dealer/target

[Senthilkumar]

how

[Barand]

43 minutes ago, Senthilkumar said:

how

Try my tutorial...

http://barringtondrew.co.uk/?page=3&tut=0

[Senthilkumar]

Ok. I will check it and come back to you if anything is required

[Senthilkumar]

Dear Banrand,

 

As per your instruction i am storing the id only for all tables. 

My question is if i want to display the name of that id how can i do this. if suppose there is a search query, then how can i search by name. Can you plese provide any sample for that.

[Barand]

16 minutes ago, Senthilkumar said:

Can you plese provide any sample for that.

http://barringtondrew.co.uk/?page=3&tut=1

[Senthilkumar]

Thank for providing tutorials