Purchase Order

[KLaw]

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!)

 

[IT PHYTOSAN]

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