Is This the Correct Way - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Is This the Correct Way

David Clement

14 months ago

Hello Richard,
I am just wondering if this is the correct way to build a Part Invoicing Database?
I tore apart the Database my company uses the best way I could and this is what I came with using the export record set into Excel, then putting it into Access.

	David Clement OP @Reply 14 months ago

	David Clement OP @Reply 14 months ago

	David Clement OP @Reply 14 months ago

	David Clement OP @Reply 14 months ago
The last image is how you initiate an invoice.

	David Clement OP @Reply 14 months ago
I have the complete Part and Customer record set ready to go. 92,000 customers and 22,000 parts

	David Clement OP @Reply 14 months ago
This is really just an extreme hobby right now. In my mind, there is a better way to do all this than what is currently being used.

	John Davy @Reply 14 months ago
You are correct with the last statement! John

	Sami Shamma @Reply 14 months ago
Hi David I would change the ID fiels in both tables so you will not have to specify the table name when using them in the same form or report: CustomerID PartID I will also follow Richard's advice and have all your table names in the singular, so it is PartT not PartsT. this will save you headache in the future

	David Clement OP @Reply 14 months ago
This what I would like to wind up with.

	David Clement OP @Reply 14 months ago

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

Next Unseen

New Feature: Comment Live View