Dynamic list of items in a table to be used on a form or subform
Posted on 2013-06-13
I'm trying to figure out how to have a master list of items for the user to use in a subform. The list of items would be in tblMasterList. This list of items would be managed via a form since items could be added at any time. No problem there so far.
I would use the master list of items in a "Budget" form. The budget I imagine will need a tblBudgetHeader and a tblBudgetDetails. The header table would have the budgetID and the budgetName. The details table would have the items from tblBudgetDetails and the link would be BudgetID.
So the budget form, (Header and Details), will consist of the header with tblBudgetHeader as its record source. The detail section will be a subform with tblBudgetDetails as its record source.
Now here's the issue... If I have the table tblMasterList and the user adds an item, how does that item dynamically get added to tblBudgetDetails so it can appear and be used on the subform?
Has anyone ever done something like this before or do I have everyone as confused as I am?