Forms, tabular subform, tabular subsubform
Posted on 2007-03-22
I have a billing form with a single client for all items on the billing form. On that billing form there are several invoices (kind of like a packing slip). I use a tabular subform linked on the customer ID#. That all works like a charm. I also have another set of data that can have multiple results for one invoice on that billing item. Ideally, I would like to have a tabular subsubform, in the tabular subform, in the main form. For example, ABC co (Client- bililng form), orders widgets ( subform), these widgets come in several colors (subsubform).
Problem - Access doesn't like me to put a tabular subform in a tabular subform. Is there something I can do here that will allow me to link the tabular subforms rather than inbed within each other?