Update drop-down depending on multiple field values?

 
1
0
-1

Hi everyone,

I have a drop-down "Price" that, if not filtered would take its values from:

"select c_menuprice , c_menuprice from app_fd_menu"

I then have 3 fields A, B, C and I would like to filter my "Price" in order to do:

"SELECT c_menuprice, c_menuprice FROM app_fd_menu WHERE field1 = A and field2 = B and field 3 = C "

A,B and C are the value that selected at the select box

What is the best way to do that? Can JavaScript done it? If yes, Can you provide the solution or sample code please? Or can I have multiple dependency for the "Price"?

Thanks a lot

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      seems like a duplicate question of Update drop-down depending on multiple field values?

        CommentAdd your comment...