dropdown list- add new entry

[abc]

I have a dropdown list with names of Authors bound to the main
connection ('Details') and looking up values in the secondary
connection ('Authors') [using backend: MS Access.

I would like the user to be able to enter a new author's name in the
dropdown list, if possible.

OR

to add a button next to the dropdown list, which will allow the user to
switch to a view called 'add new author', there they can enter the new
author's name in a text box and press save and it will automatically
bring them back to the main form with the new author's name in the drop
down list.

Please HELP!

 

[Alex [MSFT]]

The first option is, unfortunately, impossible - InfoPath does not have a
combo box control.

The second option is the way to go! We need to modify it slightly, though.
Create a button whose action is to open a new, blank form that is called
"New author entry form". This form will allow users to submit the data to
the Authors lookup table. In Submitting Forms, set the Action after submit
to be "Close this form". Then, on your main form, you might need a new
"Refresh" button that re-queries the data connection from which you are
getting the list of authors - to pick up the new author entry.

Good luck!
-Alex @ Microsoft

 

[abc]

THANK YOU! It works! =)

The first option is, unfortunately, impossible - InfoPath does not have a
combo box control.

The second option is the way to go! We need to modify it slightly, though.
Create a button whose action is to open a new, blank form that is called
"New author entry form". This form will allow users to submit the data to
the Authors lookup table. In Submitting Forms, set the Action after submit
to be "Close this form". Then, on your main form, you might need a new
"Refresh" button that re-queries the data connection from which you are
getting the list of authors - to pick up the new author entry.

Good luck!
-Alex @ Microsoft

I have a dropdown list with names of Authors bound to the main
connection ('Details') and looking up values in the secondary
connection ('Authors') [using backend: MS Access.

I would like the user to be able to enter a new author's name in the
dropdown list, if possible.

OR

to add a button next to the dropdown list, which will allow the user to
switch to a view called 'add new author', there they can enter the new
author's name in a text box and press save and it will automatically
bring them back to the main form with the new author's name in the drop
down list.

Please HELP!