Sumitting Forms connected to a database. Help!!!

[Jrangel]

I created a form that has a datasource to a SQL Server 2000 database. When i
enter the informatin on the form and hit submit the form tells me that it
sucessfully updated the database.

If i query the table in the database there is a record that has all empty
fields except for the time stamp. When i enter information in the form again
and hit submit i get an error telling me that it cannot create a duplicate
record.

What am i doing wrong? Why is the form inserting an empty record in the
database table?

 

[Clay Fox]

You need to make sure you are using you query fields to pull rows and the
data fields for the data you wish to submit.
The data should be visible in your form.

I would statr with the basic new form and follow its instructions
Drag the Query Fields in as a section
Drag the Data fields in to the view as a repeating table
Preview and do some queries and test it.
Add a new row to the repeating table and submit and see the data go in.

 

[Jrangel]

I did as you suggested and SUCCESS!!!

 

[BobCh]

Looking forward, you may want to consider moving to SQL 2005, as it
supports the XML data type for columns, and opens up a world of
options for reporting on form data.

/bac