I am completely unfamiliar with Access, but if you where to do this with SQL
server, you would create an PO table and a PODetail table and have one of the
fields in PODetail be a foreign key to the POnumber. You would establish your
data connection with the primary table being the PO and the second table the
PO Detail. You would display both tables as repeating tables with n details
per order. The PO number is asigned at the PO level and would exist only
once.
I hope you are able to extrapolate this to the Access world.
IT PHYTOSAN
"KLaw" wrote:
[Quoted Text] > I'm trying to create a Purchase Order which has a main connection to an
> Access DB and several secondary connections used to filter data. I've worked
> out all of my fields and they work fine, my issues start when I submit to the
> DB. The Main connection to the DB is an Orders table (which automatically
> assigns a PO number) and an Orders Detail table which will keep the line
> items (from my repeating table). When I submit the form to the DB, it
> assigns a PO number to each Order Detail item instead of just one for the
> main Order Form. Can anyone help me with this? (I'm not a programmer, just
> an InfoPath wannabe!)
|