Submit records to related tables

[Oliver Friedrich]

Hallo,

I'm rather new to InfoPath so I'm sure that my problem has an easy "off the
shelf" solution which I yet haven't found.

I'm using SQL Server where I have the tables Product(PK id, PK
revision,name), Adapter(PK name, description) and a table ProductionSet(FK
Product_id, FK Product_revision, FK Adapter_name). There are relations
built between the tables to create the foreign keys.

Now I want to create a form where I can choose a set of a product and a
adapter and submit this to ProductionSet. I haven't got through this until
now.

Things I've tried:

I've chosen ProductionSet as my primary datasource and added the tables
Adapter and Product (incl. defining the relations). But doing it this way,
InfoPath doesn't enable "Submit data" because there "seems to be a n:1
relationship".

I've chosen e.g. Adapter as my primary source and attached ProductionSet as
table (including relation). Now InfoPath let's me submit data, but how can
I introduce the other tables?

Since this is a common task, selecting records from different tables and
blend them to a set in a new table, I'm pretty sure, that this should be
easy to do. Maybe I haven't understood the basic idea of how InfoPath
handles with databases I couldn't figure out.

Thank you for your help!

Oliver Friedrich

 

[Harikrishna]

Hi Oliver,

The scenarios in which you have tried:
Coming to first scenario - There might not be a 'Primary Key' in that table,
the table which you have for the primary data source should have a primary
key.

Can you give the exact relationships between your tables, what has to be
submited and on what base it should be done.

 

[Oliver Friedrich]

Hi Oliver,

The scenarios in which you have tried:
Coming to first scenario - There might not be a 'Primary Key' in that
table, the table which you have for the primary data source should
have a primary key.

Can you give the exact relationships between your tables, what has to
be submited and on what base it should be done.

Hallo "Harekrishna",

thanks for replying to that post, but in the meantime I have resolved this
problem.

But I'd very greatful if you could take a look at my new post regarding
setting a control value via vba code. That'd be great of you!

Greetings Oliver