Inventory Tracking Form

[ryan400]

I need to create a form and data base for tracking inventory.

The form needs to make note of a vendor, status (incoming/outgoing), and then a series of numbers (the items all have associated numbers). is there a way for me to make a nice form that allows me to do this. Ideally I would like the database to have an entry for every item, but I would like the form to be submitted only once. So basically they type the 20 different number for 20 different items, hit submit, and the form makes 20 new rows in the database.

How would I go about making this?

[trevor40]

try using the inbuilt help system in access, start with table design, then form design. You probably need 2 tables main and parts, they need to be linked so many parts can be linked to one record in the main table. the inbuilt design wizard should be able to do this for you. then create a form using the wizard and base it on both tables, you will need to have the parts table as a sub form within the main form, access will take care of the relationships so lone as the initial table design is correct.

[Xipooo]

I think you should study up on database design and normalization to first learn how to create a good foundation of your database. Then from there learn how to query your data from those tables. Then finally how make forms that use your queries to interact with your database tables.

You really want to learn the basics first before just jumping into a project. It is very easy to design a database poorly at the start but not realize it until it's too late and have to either start all over again or put a ton of work into fixing it.

There are lots of good videos on Youtube, and the website http://allenbrowne.com/ has lots of good information to help you get started. There is also the Tutorials section of this forum where many tutorials are posted: https://www.accessforums.net/tutorials/