Creating invoice input form in 2007

[mogo3xc]

Hey all,



I'm an Access newbie so forgive me if any of this seems naive, but I'm desperate so I'm coming to you all for help.

Basically, for my job, we are looking for a way to input customer purchases and invoices via Access. I'm looking for a way to input the customer, customer ID, product purchased, product purchase ID, whether they're buying it by the pound or by the item (it's for a farmer's market type deal, so we're looking for an all-in-one invoice system that simply allows us to put in the credentials and will save it in a database for us.), and the grand total of the purchase.

I've been fiddling around with forms and such to no avail, but I'd appreciate it if I could get some guidance on where to go from here.

[ranman256]

you need an invoice tbl.
in this form the customer combo box would get data from the tCustomer table.
The product combo would get items from the tProducts table.
Qty or Weight, (depending on the product)
Total

instead of writing directly to the tInvoices table, I would build an invoice in a 'working' table. Then if
everything in the transaction is valid...save to the tInvoices table.

[orange]

I've been fiddling around with forms and such to no avail....

I don't think this is a viable strategy. Getting your tables and relationships designed to support your business requirements is key.
I'm going to suggest you look at this free, generic data model of Customers and Invoices to get an idea of the things(tables and relationships) involved.
And an approach to creating a database.
And a tutorial that you must work through, but you will learn about table design.

Good luck with your project.