Submit to Access

A

abc

I need to create a form where the user will be able to:
1. Search for a record and if a record is found they should be able to
edit and save their changes
2. If no record is found, they should be able to create a new record
and submit to save.

I would like this all in one view.

I'm connected to an access db. My two tables consist of a parent &
child, 1:M relationship. (primary key: record id)

The problem I am facing is creating a new record. Right now, the user
can create a new record by filling in the fields of the parent table
and clicking submit. Then they have to "query" for that record, and
once the record populates with the new record ID, the user is able to
fill in the "child" fields, and may submit.

Is there way the user shouldn't have to query for the new record in
between steps?
 
S

Scott L. Heim [MSFT]

Hi,

How did you setup your InfoPath form? Are you using a "Master/Detail"
control? This control is designed specifically for this type of situation -
parent/child.

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Top