
So I'm pretty new to Access. I've grasped forms and VBA pretty well, but I'm still finding it a bit daunting to determine if my table structure is efficient, and if it's setup to make future expansion easier.I have a business creating custom items and selling them. Based on what I've learned, I should have the below tables to properly structure my database. In the future I also plan to add tables for inventory and "recipes" for my products. That's to say, a blueprint for what quantity of raw inventory items I need to create an item and at what cost. Currently the system would involve me entering customers, entering orders for them and tracking statuses (with order invoices showing the items/quantities on the orders), and tracking payments for said orders.Below I've included a link to my relationship map. Can any of you Access pros take a look and let me know if you see an incorrect relationship, missing field, or anything else that you think could be improved upon.https://ift.tt/2yX7PPj in advance for any help, it's much appreciated! via /r/MSAccess https://ift.tt/2OuLaii
No comments:
Post a Comment