Repeating table in a form connected to Access database

[jel]

I tried to find the answer by reviewing ?'s from the newsgroup, but didn't
find it. So, here my ?: Why am I getting a "A repeating table must be bound
to a field or groups that repeats." error msg when I try to add a repeatign
table in an optional field to the data query section of a form I'm creating
that has a data connection to an Access database, espeically when I'm trying
to bind it to a group that's repeating(folder had the picture with a lock and
blue repeating arrow on it under my data fields folder). Thanks!

I want my form to be a little more complex than the one the training shows
you how to make in the lesson on connecting a form to a database (Good lesson
though).

Also, how do you make your query fields (in the query section of the form)
query the database regardless if the format the user types the text.
Example: In the lesson
http://office.microsoft.com/en-us/infopath/HA011199501033.aspx when the user
adds "Coho Winery" when the user then tries to search for "coho winery", it
can't find it. What if my user even put "coho", I'd like for the search to
give the nearest thing. How do I fix that search function? In my form or in
the database?

Thanks!!!

 

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

These are all limitations of InfoPath when you bind a form to a database. You
cannot modify the data source InfoPath creates for you (as you saw, there was
a lock present), and the query capabilities are limited in that you can only
perform exact searches.

Unfortunately, for complex scenarios, you'll have to write code to do the
querying as well as to submit your data to the database.

 

[jel]

Figured as much. Thanks! Any ideas of places where I can copy and learn
code to write for Infopath in order to do what I described? Also, I thought
of an idea and wondered if it might work:

Could I make one section of the form for data input and review (the data
connection part of it) and add a separate area that sends an email to someone
notifying them of the input to the database?

 

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

Regarding places to copy and learn: This newsgroup is a good place to start,
but you have to know what you're looking for otherwise you won't find
anything. Another place you can go is infopathdev.com; they have a forum
where you can ask questions and you can also search their forum to find
answers. You can also learn much by doing the InfoPath labs:
http://msdn2.microsoft.com/en-us/office/aa905438.aspx

There are basically two ways you can do this: Either write ADO code or call
a web service to save the data to your database.

Regarding your second question: You can always create a submit data
connection to an email address that will send the form as an attachment. With
a little bit of extra coding using the EmailAdapter you can customize the
body of the email to include text to tell the user what to do. You should be
able to find code snippets on how to do this online by searching on
EmailAdapter (also see
http://msdn2.microsoft.com/en-us/library/aa167746(office.11).aspx).