P
Praxis
Here is my set up...
Tables:
-customers (CustID, Name, Address, etc) - CustID being the primary field.
-invoices (Invoice#(autonumber), CustID, Subtotal, Shipping, Total) - Invoice# being the primary field.
I want a form that creates an invoice. I want the new invoice# to link to the invoice table and fill in the appropriate fields and allow me to type in a previous invoice# and pull up that invoice detail. In the same form, I want the customer information to pull up (if it already exists in the customers table) when the CustID is entered or start a new CustID (if non existant in the customers table).
Also, since the details of the invoice are not related to the invoice table (only the Invoice#, CustID, Date, Subtotal, Shipping, and Total) how will it pull up the details later?
Tables:
-customers (CustID, Name, Address, etc) - CustID being the primary field.
-invoices (Invoice#(autonumber), CustID, Subtotal, Shipping, Total) - Invoice# being the primary field.
I want a form that creates an invoice. I want the new invoice# to link to the invoice table and fill in the appropriate fields and allow me to type in a previous invoice# and pull up that invoice detail. In the same form, I want the customer information to pull up (if it already exists in the customers table) when the CustID is entered or start a new CustID (if non existant in the customers table).
Also, since the details of the invoice are not related to the invoice table (only the Invoice#, CustID, Date, Subtotal, Shipping, and Total) how will it pull up the details later?