E
ec
How do I make a spreadsheet type data entry
with the following table?
project_id, year, expense_id, amount
1 2003 1 $100
1 2003 2 $50
1 2004 1 $90
2 2003 1 $100
2 2003 3 $40
2 2004 1 $50
I would like the data entry screen to be
as follows:
project_id: 1 (combo box to select project)
expense_id 2003 2004 total(calculated field)
1 $100 $90 $190
2 $50 $50
total(calc.) $150 $90 $240
If I denormalize the table with the years as fields then
I can easily set up the spreadsheet form.
with the following table?
project_id, year, expense_id, amount
1 2003 1 $100
1 2003 2 $50
1 2004 1 $90
2 2003 1 $100
2 2003 3 $40
2 2004 1 $50
I would like the data entry screen to be
as follows:
project_id: 1 (combo box to select project)
expense_id 2003 2004 total(calculated field)
1 $100 $90 $190
2 $50 $50
total(calc.) $150 $90 $240
If I denormalize the table with the years as fields then
I can easily set up the spreadsheet form.