[eluser]Unknown[/eluser]
Hi,
I’m having some problems using Grocery CRUD with my database...
Here my table design.
Orders :
id, products_id,qty,discount, total,etc...
Products:
products_id,unit_price, discounted(bool), etc...
The rule is, if products is discounted, in add or edit orders we can set the discount value(based on orders qty) else field is hidden, and total field is hidden in add or edit but the value will be (unit_price - discount).
i just can't figure out how to get and set those field values using Grocery CRUD.