P
poranui
I am just starting out with InfoPath. I have done standard database
work for years, so that is not the problem
I have a form in which for example am creating a request for action.
This request can have many different categories. The list of
categories is stored in a separate table. There is the option to end
date each category.
Now I can populate the main data connection fine, and I can populate
the drop down lists for peoples names. But I cannot get the many to
many categories to populate.
I managed to get it to populate a single selection list, but obviously
got the error that it could only be bound to the first item in the
list.
I finally found out where the multiple selection list hides itself
(had unintentionally created a browser enabled form to begin with)
So can someone tell me how to get this multiple selection list
populated with the category options?
I am assuming that it is something exceptionally basic that I am not
getting about creating the data connection.
I have tried using the main connection and linking the three tables
that way, I have also tried creating a seconday connection to do it
that way.
One error I get is that the the multiple selection list box control
must be bound to a repeating field with a text data type. However the
category description is a text data type.
work for years, so that is not the problem
I have a form in which for example am creating a request for action.
This request can have many different categories. The list of
categories is stored in a separate table. There is the option to end
date each category.
Now I can populate the main data connection fine, and I can populate
the drop down lists for peoples names. But I cannot get the many to
many categories to populate.
I managed to get it to populate a single selection list, but obviously
got the error that it could only be bound to the first item in the
list.
I finally found out where the multiple selection list hides itself
(had unintentionally created a browser enabled form to begin with)
So can someone tell me how to get this multiple selection list
populated with the category options?
I am assuming that it is something exceptionally basic that I am not
getting about creating the data connection.
I have tried using the main connection and linking the three tables
that way, I have also tried creating a seconday connection to do it
that way.
One error I get is that the the multiple selection list box control
must be bound to a repeating field with a text data type. However the
category description is a text data type.