calling records for specific id
Posted: Sun Aug 21, 2016 10:43 pm
Hello. I would like the form to call only the records connected to specific id. I would like to do something like this:
I've got table orders which is connected with table quotes with the key orderID (pk in table orders, and fk in table quotes). And I would like to have form, that would be open from specific order level and showing only the records connected to that specific order. How can I reach that?
And another question: I would like to have prices in table/form quotes changed dynamically when I change size (prices depend on width and heigth). How can I call js function to run php script which would take the correct price from db (price is taken from pricelist table in db and depends on width and heigth)?
Thanks for any help.
I've got table orders which is connected with table quotes with the key orderID (pk in table orders, and fk in table quotes). And I would like to have form, that would be open from specific order level and showing only the records connected to that specific order. How can I reach that?
And another question: I would like to have prices in table/form quotes changed dynamically when I change size (prices depend on width and heigth). How can I call js function to run php script which would take the correct price from db (price is taken from pricelist table in db and depends on width and heigth)?
Thanks for any help.