Forms in Sharepoint: lookup field auto-update capability on entering data?

[TSchaeffer]

Hi all,

I'm looking to design a form for sharepoint that will have a number of
fields that are lookup fields. For the lookups, I would like the user to be
able to enter in a value that does not exist in the lookup's source list of
values (in addition to choosing from what's already there) and if a new
value is added, have it be added to that lookup's source list on submitting
the form.

I have a feeling that this functionality might be available in Infopath but
am not sure. Is this the case? If so, could anyone suggest a
site/book/lesson that would walk me through this? If not, any suggestions
on where I could go or what I would need to do to find this functionality?
I spoke with our developer who didn't sound very upbeat about this being out
there.

Any thoughts or suggestions appreciated. Thanks in advance.
TS

 

[Clay Fox]

So you have SharePoint lists you want to use as data sources in your form but
then also allow new list items to be created?

This is possible in InfoPath. You can insert or update SharePoint Lists.

It is a bit complicated but it is doable. You can find some examples on
http://www.infopathdev.com or you can email me here and I could show you some
examples.
http://www.infopathdev.com/members/clayfox.aspx

 

[S.Y.M. Wong-A-Ton]

InfoPath does not offer this functionality out-of-the-box, so you will have
to write code for it. It *can* be done, though.

You would have to maintain a separate list of the items that do not exist
somewhere (either in the Main data source of the form or in a secondary data
source) and then on submit, persist those items to your data store. Or you
could do something like in this article:
http://enterprise-solutions.swits.n...ly-type-and-add-new-item-to-dropdown-list.htm

 

[Mike Walsh]

Was it really necessary to send this question to so many newsgroups?

Even if we accept that it is both an InfoPath AND a SharePoint question,
there is absolutely no need to post it to more than one SharePoint
newsgroup.

..general for instance is for questions that don't fit in any other
SharePoint newsgroup so it's obviously not something that you add in if
you are posting to any other SP newsgroup.

..development_and_programming is for Programming questions. Is this a
programming question ? No, it's not.

Think next time please and *select* - don't just hammer every newsgroup
in sight.

Mike Walsh
WSS FAQ http://www.wssfaq.com / wss.collutions.com
I regret that private e-mail questions will not be answered

 

[michael haskell]

TS,

I found this post after a lot of searching. I'm curious if infopath was a workable solution for you, I am in the same boat on you on this one.

Sounds like a lot of users need this feature!

Thank you in advance,
Mike