J
Jonathan Lyall
Anybody got an idea of what to do here.
I have a database from a financial system sql based, from which I want to
view related records from 3 tables. I have created views of these three
tables. I need to save data into a 4th table.
These are existing
VIEW A
VIEW B
VIEW C
This is the new one.
TABLE D
I have added another TABLE E that links the tables above together using
standard pk fk relationships.
When I query using the pk of TABLE E - I get 1 row from TABLE E, 1 row from
VIEW A, many rows from VIEW B and VIEW C and many rows FROM TABLE D.
I can add rows to a repeating table of TABLE D in the infopath form quite
happily but I cannot submit. The message I get is that the tables concerned
do not have uniqueness constraints or primary keys.
I have tried to to turn this around by putting the VIEW ABC into a secondary
datasource and this solves my submit problem - but the secondary datasource
views are not populated when I query.
This job would be trivial to do using 2 stored procs and an ASP .Net page
but the marketing guys have sold infopath :-(.
Anyone got any thoughts that would help.
Cheers
Jono
I have a database from a financial system sql based, from which I want to
view related records from 3 tables. I have created views of these three
tables. I need to save data into a 4th table.
These are existing
VIEW A
VIEW B
VIEW C
This is the new one.
TABLE D
I have added another TABLE E that links the tables above together using
standard pk fk relationships.
When I query using the pk of TABLE E - I get 1 row from TABLE E, 1 row from
VIEW A, many rows from VIEW B and VIEW C and many rows FROM TABLE D.
I can add rows to a repeating table of TABLE D in the infopath form quite
happily but I cannot submit. The message I get is that the tables concerned
do not have uniqueness constraints or primary keys.
I have tried to to turn this around by putting the VIEW ABC into a secondary
datasource and this solves my submit problem - but the secondary datasource
views are not populated when I query.
This job would be trivial to do using 2 stored procs and an ASP .Net page
but the marketing guys have sold infopath :-(.
Anyone got any thoughts that would help.
Cheers
Jono