Intro

This inventory management solution is designed to help businesses of all sizes manage/import their inventory with ease. Whether you are a small business just starting out or an established company looking for a reliable, secure, and efficient system to manage your inventory, this solution has all the features you need to keep track of your inventory and keep your business running smoothly. With features including custom item tracking, streamlined sales process, and powerful reporting capabilities, this system offers everything you need to manage your inventory in one place.

1. Products table:
   • Product ID = Text field, Sequential ID property
   • Name = built-in
   • Description = text field
   • Category = single select
     • fruit, citrus, meat, seafood
   • Price = numeric currency field
   • Quantity = numeric

2. Sales table:
   • Sales ID = text field, Sequential ID property
   • Customer ID = many to one linked field to the customer table
   • Order Date = date field
   • Total Cost = numeric currency field

3. Sales Items table:
   • Sales Item ID = text field, sequential ID property
   • Sales ID = many to one linked field to sales
   • Product ID = many to one linked field to the products table
   • Quantity = numeric field

4. Customers table:
   • Customer ID = text field, sequential id property
   • First Name = text field
   • Last Name = text field
   • Email = text field of type email field
   • Phone = text field of type phone field

Video only