Megan
Registered User.
- Local time
- Today, 07:47
- Joined
- Jun 3, 2011
- Messages
- 23
Time to let my noobishness shine. 
My fundamental question is can a subform be placed within a subform in a web database that will be used with Access 2010, SharePoint 2010, Access Services?
For example, my goal for one of the forms is to have:
Main form = Customer information
Subform = line item categories (kitchen, office, bathroom,...)
Sub-subform = line items (dish soap A, dish soap B, paper towels,...)
I accomplished this in a non-web database, but in a web database to be published with Access Services, it is proving challenging. Thanks for reading!
[Edit: Well I think I've figured out a workaround (though probably the long way around). Since this is part of a hybrid database, I created a direct relationship between the main customers table and the line items table (bypassing the categories table). The line items table now has a "Category" field. Bummer that the customer has to enter the category repeatedly for each item in that category, but such is life and the tradeoff of having a web submission form seems worth it. Anyway, after the customer enters their information into the form, it looks like the data can be appended without too much hassle to the appropriate tables and then deleted from the tables that initially hold the submitted data. Please tell me if I'm nuts for doing it this way. ]
My fundamental question is can a subform be placed within a subform in a web database that will be used with Access 2010, SharePoint 2010, Access Services?For example, my goal for one of the forms is to have:
Main form = Customer information
Subform = line item categories (kitchen, office, bathroom,...)
Sub-subform = line items (dish soap A, dish soap B, paper towels,...)
I accomplished this in a non-web database, but in a web database to be published with Access Services, it is proving challenging. Thanks for reading!
[Edit: Well I think I've figured out a workaround (though probably the long way around). Since this is part of a hybrid database, I created a direct relationship between the main customers table and the line items table (bypassing the categories table). The line items table now has a "Category" field. Bummer that the customer has to enter the category repeatedly for each item in that category, but such is life and the tradeoff of having a web submission form seems worth it.
Anyway, after the customer enters their information into the form, it looks like the data can be appended without too much hassle to the appropriate tables and then deleted from the tables that initially hold the submitted data. Please tell me if I'm nuts for doing it this way. ]
Last edited:
