K
KLaw
Having trouble getting a Purchase Oder form to work: form is linked to an
Access database with an Orders table (which generates a PO Number) and an
Orders detail table (which should show the line items of the Order). On the
form I have a repeating table with items (Product number, unit cost,
quantity, extended price, etc) and an expression box for the total of all the
line items. When I submit to the DB the i end up with a PO for each line
item instead of one for the form. Any ideas?
Access database with an Orders table (which generates a PO Number) and an
Orders detail table (which should show the line items of the Order). On the
form I have a repeating table with items (Product number, unit cost,
quantity, extended price, etc) and an expression box for the total of all the
line items. When I submit to the DB the i end up with a PO for each line
item instead of one for the form. Any ideas?