planning for Projects /w budgets

[wshs]

i have been brain-storming to come up /w best way to do this..
I currently have 3 tables.

] tbl_ProjBudget : ProjID | ProjBudID | BFSIX | ProjBudget | EncAmt | EncPaID | EncBal | ProjBudBal

] tbl_ProjName : ProjID | ProjIDName
ex. ProjID = exhibit1
ProjIDName = Liberty OTB

] tbl_ProjBudName : ProjBudID | ProjBudName
ex. ProjBudID = ex211
ProjBudName = exhibit remodeling

Im trying to create a form(s) which will allow users to encumber amount from Main Budget(different table) and carry it over to the Project table. Then be able to create a project using that fund.
ex. User selects a budgetline and transfers 10,000. And then be able to create projects using that fund.
ProjID: Test 1
ProjName: Liberty OTB
ProjBudget: $10,000

Proj Budget Budget Committed Spent Bal
Budget Desc amount
Line | | | | | |
test 11 | marketing| 2,000 | 1,000 |1,000 | 0 |
test 12 | promotion| 5,000 | | |5,000 |
test 13 | TV add | 3,000 | | |3,000 |
10,000 8,000

1. Contract with ACO for $2,000 for marketing
2. Paying ACO against commitments $1,000

It's hard only because user needs to be able to create their own projects (including ProjBudline, Budgetdesc, budgetted amount). User creates and distribute money with that 10,000 they first transferred.

I know this is very ambiguous and all but any kind of help will be appreciated.

here are my thoughts.
First create a form which user can type in project id, name, budget amount. also a list box where user can select where the money should be transferred from.
next step is the main problem for me. I have no clue how to let user type in multiple budget lines and amounts to create their own projects. can i just simply do a form within form in a database mode, and they can jus ttype all in at once?

 

[lameid]

Something does not seem quite right about your table structure but maybe it is just counterintuitive to me.

Anyway, it sounds like you want a main form and a subform... You make a subform by creating a form and then dragging it into another form. Your detail form should be your subform. The really imporatant part is to set the Master And Child fields properties to point to whatever links the main form to the subform. Perhaps ProjID for tbl_ProjName (main form) and tbl_ProjBudget (subform).

Also, if you have not done much with your database, I would recommend removing the underscore from your table names. Underscores just get to be annoying in the long run.