InfoPath Dev

Hi Don, I am working on rolling out the form and the integration with Access seems to be creating some issues. Is there a reasonable way to convert an InfoPath form to be SharePoint based or would I need to start over?

This is the more flushed out original form. For this one I set the menu selections up as check boxes and but the question that show/hide each section. The problem with this method is all the menu choices are on the same table as the customer visit and it creates a bad database structure and does not allow for most of the reporting I want to run. ...

Here is the very rough version of the form in its current set up. I like the idea of the cascading drop downs but I am not sure how to set that up with the Access Back End. Since the MenuCatergoryTbl is tied to the MenuItemTbl and not the CustomerVisitTbl, if I add it to the data source it will not allow me to submit data.

The current work around I have come up with is to have the drop down box list all the options (about 120) with the menu items name being set up as Category:Item Name so for example Breakfast: Eggs Benedict. This prevents the duplication issue but I really do not like 120 choices in the drop down. Any other suggestions?

Another option I thought of (and I am not sure if this can be done) would be to have some type of control that allows the user to select a menu category (Appetizer, Salad, etc) and then select their menu choice from within that category. If that control could be set up in a repeating section. The user would just pick the category for each new ...

Hi Don Stephan, Here is a screen shot of the form in which I have selected a breakfast item and have not selected the appetizer item yet. The drop down is displaying the MenuItemID of the Breakfast Item. When I set the drop down value to blank when it is not blank it does not store the data properly (the drop downs are just blank)

This is my first question here so my apologies if I am wording it poorly. Any help would be greatly appreciated. I am food distributor chef and I have customers that come into my kitchen to see new ideas. I am creating a form that their salesman would fill out before the visit and submit. The form would allow them to chose what items they ...