Hey all...
To clarify my previous post a little better:
I am writing a little database for a local garage to print invoices.
I got a form called frminvoiceacquire that first has a combo box with all customers in it. From that they select the customer that needs an invoice created for. Then it pops up another combo box that has all vehicles that customer owns. They then select the vehicle they did the work on.
That form simply passes the customerID and vehicleID to my frminvoice table acting in data entry mode.
Now I want to take the key customerID, and select all the customer information (first name, last name, ect) and vehicle information to frminvoice (showing up in text boxes) and then store it into the Invoice table so I can generate some kind of report that will be a receipt for the customer or so it could be viewed later.
I know this is got to be pretty simple. Hope that helps!
Thanks again!
To clarify my previous post a little better:
I am writing a little database for a local garage to print invoices.
I got a form called frminvoiceacquire that first has a combo box with all customers in it. From that they select the customer that needs an invoice created for. Then it pops up another combo box that has all vehicles that customer owns. They then select the vehicle they did the work on.
That form simply passes the customerID and vehicleID to my frminvoice table acting in data entry mode.
Now I want to take the key customerID, and select all the customer information (first name, last name, ect) and vehicle information to frminvoice (showing up in text boxes) and then store it into the Invoice table so I can generate some kind of report that will be a receipt for the customer or so it could be viewed later.
I know this is got to be pretty simple. Hope that helps!
Thanks again!
