P
Paul
I am creating a Form from an Access Database. All of the
items I want on the form are in the same table in my
database. Pretty simple so far. One of the fields is for
a Purchase Order Number. I want to have the form only
make the user enter the Purchase Order Number Once and
then under that have a repeating section for information
about the PO. I need to have the user be able to enteries
using the repeating section but not have to enter the
Purchase Order Number again. When I try this it submitts
fine to the Database will only place the purchase order
number in Access next to the first repeating section
entered in the Infopath form. Additional information
entered in additional repeating sections will show up in
the access table but will not have the Purchase Order
Number in its row. Is there a way to have a one to many
type of relationship and have that One Entry (In my Case
Purchase Order Number) be entered in the access table for
however many repeating section entries there are. Thanks.
Paul
items I want on the form are in the same table in my
database. Pretty simple so far. One of the fields is for
a Purchase Order Number. I want to have the form only
make the user enter the Purchase Order Number Once and
then under that have a repeating section for information
about the PO. I need to have the user be able to enteries
using the repeating section but not have to enter the
Purchase Order Number again. When I try this it submitts
fine to the Database will only place the purchase order
number in Access next to the first repeating section
entered in the Infopath form. Additional information
entered in additional repeating sections will show up in
the access table but will not have the Purchase Order
Number in its row. Is there a way to have a one to many
type of relationship and have that One Entry (In my Case
Purchase Order Number) be entered in the access table for
however many repeating section entries there are. Thanks.
Paul