Help with SQL

[JRohde]

Hi,

I am trying to create a form that has a projekt number field on the
main page. There is a button, that shows another view containing
project data based on what project number the user has typed in the
projekt number field.

I have managed to create a condition with an SQL clause, but I need to
add a "where-clause" besed on the project number field. How do I
reference this form field in the SQL statement?

I hope I'm making sense here...

Jakob

 

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

Try looking into this article:
http://enterprise-solutions.swits.net/infopath/query-access-database-list-numbers.htm

It modifies the SQL statement of a form by adding a WHERE-clause to it that
is composed of values from a field on the form.