Invoice Form - Access Developer Network


	Back to Access Developer Network Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Invoice Form

Spencar Diedrich

4 years ago

I am creating a database to track my trucking business. I have everything setup and working for entering in all of my information for my trucks and loads each truck gets. I now need to setup the portion to invoice the different companies that I haul for. This is and endless list and keeps growing by the day. Each load is independent from each other(Driver, product, rate, weight, ect) I currently have the forms and queries done that collect all the information correctly I have a form that displays the customer info and a subform that has all the customers loads. How do I create an new invoice every time I want to invoice a customer and have each load get tied to that? Struggling a bit with this one.

	Spencar Diedrich OP @Reply 4 years ago

	Adam Schwanz @Reply 4 years ago
Have you tried this? Invoicing

	Spencar Diedrich OP @Reply 4 years ago
Thank You. It finally clicked!! I was setting this up all wrong and not using all the fields and primary keys! Time to start over and redesign a few things.

Spencar Diedrich OP @Reply

4 years ago

Still having trouble.

In my business I have suppliers give me load numbers. This allows me to send a truck and pick up that load. When I drop the load off I get information that allows me to bill my Customer. When I get the initial load number I enter that information into a LoadT. When I get the unload information I have another form that I want to get the initial load number from a combo box and enter my information for invoicing. When I get the load number from a combo box it is creating a duplicate form in my LoadT. Do i need to make another table for the unload information or is there a way to add information to that record from another form?

	Richard Rost @Reply 4 years ago
Sounds to me like your load and unload data can go in the same record in your LoadT. Just search for that load number and then enter the unload data. But I don't know your business, so I'm just basing this on what you've told me. It would be like shipping a product. The "date shipped" and "date delivered" would both be fields on the OrderT.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Network.

Next Unseen

New Feature: Comment Live View