InfoPath form with Database Connection used for Purchase Order

K

KLaw

I am trying to create an InfoPath form which is linked to an Access DB to
create a Purchase order. I was able to have the form query the DB and return
specific data, now I want to be able to add a field which allows the user to
enter a quantiy, then submit that entire record to the DB - any ideas? The
products list is too large (2000+ records) to just create a drop down box,
hence I've limited the list by using the query. But now I just can't figure
out how to submit the data back to the DB with an additional field added. I
have to believe someone has tried this! Thanks for any help.
 
K

KLaw

I worked this out myself with help from reading other postings - looks like
the trick is to use filters and rules (current () is a powerful tool!)
 
Top