database

[MCC]

Hello,
I create a form with infopath 2003 sp1 and Sql database. I would like to
fill a field with a secondary data source. but If the user couldn't find the
right field, he can add the new field. and after i would like that my
secondary data source will be updated with this new field.
I hope it's clear. I am not really fluent in english.
Thanks in advance for your help.
MCC

 

[mag31]

Hi MCC,

Infopath only allows a single "main" connection to a database, over which
you can submit your information. You therefore have two options one is to
code the solution (not ideal). The other is to include your secondary table
as part of your main data connection. This may or may not be easy depending
on your data structure.

What you could do is create a new table in your db called "Upload", with an
upload_id column. Then include that column into your main data table and your
secondary table.

When you create your datastructure it should look like:

upload
- upload_id
|
--- main_table
- main_table_id
- secondary_table_id
- upload_id
|
--- secondary_table
- secondary_table_id
- upload_id

Then you can use the secondary table as a secondary source for your drop
down list, but include an option to add new secondary table items at the
bottom of your form if they aren't provided.

Hope this helps,
Mark Grant
Cambridge Convergence Limited

 

[MCC]

ok Thanks it works well like that.
MCC

Hi MCC,

Infopath only allows a single "main" connection to a database, over which
you can submit your information. You therefore have two options one is to
code the solution (not ideal). The other is to include your secondary table
as part of your main data connection. This may or may not be easy depending
on your data structure.

What you could do is create a new table in your db called "Upload", with an
upload_id column. Then include that column into your main data table and your
secondary table.

When you create your datastructure it should look like:

upload
- upload_id
|
--- main_table
- main_table_id
- secondary_table_id
- upload_id
|
--- secondary_table
- secondary_table_id
- upload_id

Then you can use the secondary table as a secondary source for your drop
down list, but include an option to add new secondary table items at the
bottom of your form if they aren't provided.

Hope this helps,
Mark Grant
Cambridge Convergence Limited