required form

[Russ]

Could some one tell me how to have tables in my main data source that are not
required? right now my access database has several tables. one parent and the
other or child tables so to speak. how do i have them all in my infopath
datasource with out having to fill them out. right now if i dont fill them
out, the primary key that links the tables is automatically filled in and a
record is created in teh access database. how do i prevent this?

thank you
russ

 

[Muhammad Sheraz Siddiqi]

Hi Russ,

Would you mind explaining your question clearly, what you actually need and
what is the problem you're facing? I'm unable to understand your questions.

Thanks,
-Attari-

 

[Russ]

sorry for the confusion.
i have several tables in my main datasource. certain tables may or may not
be filled out based on the specific encounter with the patient. if i do not
select any answers in these fields to the specific table, then i do not want
a record created in teh access database. is this possible?

right now, if i do not set the values, the primary key is still filled in in
the access table and the rest of the fields left blank.

how do i make a entire section optional?

thank you
russ

 

[Scott L. Heim [MSFT]]

Hi Russ,

The following steps should give you what you need - this assumes your
tables are related and you have, say, Repeating Sections or Repeating
Tables on your InfoPath View:

- Open your InfoPath solution in Design View
- Right-click on your "top-level" section or table and choose Properties
(for example, if I have a solution based on Customers, Orders and Order
Details from the Northwind sample database you would want to display the
Properties screen for the Customers section)
- On the Data tab, click the Modify button
- Click the Edit Default Values button
- Uncheck the "child" table (using the example above, you would uncheck the
Orders table)
- Click OK 3 times to get back to your InfoPath solution
- Repeat the above steps for each child table until you get to the last one
(again, using the example above I would now display the Properties screen
for the Orders table and uncheck the "Order Details" table. As Order
Details is the last table in my data source, I would now be done.)

What this accomplishes is to allow you to enter one table at a time (in
relationship order) without automatically adding a record to the child
table. The key thing to know here is this: in order to enter a record into
the child table, you will need to make sure you have the default link, a
button, something that enables the user to "click here" to add a record to
the child table.

I hope this helps (and makes sense!)

Scott L. Heim
Microsoft Developer Support

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