I
INTP56
I have a situation replicated as the following:
I have an Author table, and a Book table. An Author can have many books, and
a book can have many authors.
There is a join table in the middle, with an AuthorID column(NOT NULL) and a
BookID column(NOT NULL), a UNIQUE constraint using both columns, along with a
comment column(NULL).
My InfoPath form is using the JOIN table as the Main Data Source.
In the data section, for each record in the join table, I would like to
display additional information from both the Author table and the Book table.
When a user wants to make a join, when they select an Author or Book, I would
like that extra information to be visible.
Offhand, it would seem I need a Master/Detail control using Secondary Data
Sources to accomlish this. I can't add the extra tables to the main data
source, because then I can't submit. I can make a VIEW in the database that
does this, but then I can't submit, even with INSTEAD OF triggers on the VIEW.
Does anyone else have this kind of situation/need?
Bob
I have an Author table, and a Book table. An Author can have many books, and
a book can have many authors.
There is a join table in the middle, with an AuthorID column(NOT NULL) and a
BookID column(NOT NULL), a UNIQUE constraint using both columns, along with a
comment column(NULL).
My InfoPath form is using the JOIN table as the Main Data Source.
In the data section, for each record in the join table, I would like to
display additional information from both the Author table and the Book table.
When a user wants to make a join, when they select an Author or Book, I would
like that extra information to be visible.
Offhand, it would seem I need a Master/Detail control using Secondary Data
Sources to accomlish this. I can't add the extra tables to the main data
source, because then I can't submit. I can make a VIEW in the database that
does this, but then I can't submit, even with INSTEAD OF triggers on the VIEW.
Does anyone else have this kind of situation/need?
Bob