Dear All,
I have a situation like this,
I have four tables,
-
work_category => work is belong to a category
-
work => the work table
-
budget => the budget table
-
budget_detail => contains work (one to many relationship with work)
I want to make a modelform to handle the entry of budget_detail, instead of add one detail at a time, I want user to just click a work_category, then all works belong to selected category will be displayed, so that user only need to entry the quantity. But I do not want to save all works in budget_detail. during the saving process, I will only save those that are not 0. How can I achieve this?
My current solution is to store all works as entry in budget_detail. This is becoming slow and take huge amount of database space when the work table is growing.
TIA
Daniel