I Have the following tables
tbl_budget
-----------
budgetid
budgetmonthid
budgetyearid
budgetspend
budgettarget
itemid
tbl_item
----------
itemid (foreign key in tbl_budget)
item
I want to display the above data in a table that displays the data month by month or quater by quater
what is the best way to do this?
tbl_budget
-----------
budgetid
budgetmonthid
budgetyearid
budgetspend
budgettarget
itemid
tbl_item
----------
itemid (foreign key in tbl_budget)
item
I want to display the above data in a table that displays the data month by month or quater by quater
what is the best way to do this?