I am developing a database to track yearly budgets (by month) for several business entities. Each entity has several departments. In the underlying table each record is one dollar amount for one line item for one department i.e. Advertising expense for the parts department for the month of January at the Westbrook entity.
I think I can create a form to select the entity and then a subform to select the department and another subform list all of the revenues and expenses by month.
My questions are these:
1. Is this strategy possible and is it efficient?
2. How do I link the subforms together and to the form so that the table records entity and department (Westbrook and parts) in each record without having to select them for each record?
3. Can I put all of the months (multiple records) on the same subform in order to accomodate the data entry specialist?