Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Manage Rental Inventory    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Track Products
James Hopkins 
     
5 years ago
Hey, I been working on a Service Based Database that Tracks Product (Chemicals & Fertilizers) Applications and Activities. I have created two Tables for the Chemicals and Fertilizer and their Activities and Applications. I am wondering if I should combined the Tables and Forms together to one. Also, wondering what's the best way to do the "Tracking, Appling, and Showing the Activities of the Products"?
Scott Axton  @Reply  
        
5 years ago
James the best answer is a definite maybe.  I don't quite understand the terminology you are using - "activities of the products".

I do understand a little bit (I think) if what you're trying to do. One of my former partners had a lawn care service.  The reason I recommended the Work Order Seminar.

With Access you can be as simple or as granular as you need to be.
Thing is I would combine all of your items in to one table that you are selling.
Whether you invoice for 1 Application or 3 hours of labor / application.  The next line item might be 4 lbs 10-10-10 poultry fert. The next might be mowing,  10K sq/ft  Understand?
The products and services can be broken out how ever you need but all the "items" you offer go in your products table whether it's widgets or services.

Then down the line you can go back through, using reports, to show the items you need to track.
You has x hours of labor, used y lbs. of pre-emergent, z gals of ground clear.  And so on.

Scott Axton  @Reply  
        
5 years ago
Check out the Chef's Kitchen Helper video.   It might help you to think outside the box a bit.
Apply the things you use and do to making a recipe.  

Also look at the {1515} if you haven't already.
Scott Axton  @Reply  
        
5 years ago
Richard Rost  @Reply  
          
5 years ago
Hi James. It's always hard trying to help someone who isn't a student that's taken my courses. You're a Gold Member, which is wonderful. Welcome. But I have no idea what you know. With my regular students, I know if they've taken the Beginner courses, Expert courses, etc. So... I'll just tell you how I would set it up. ONE table for products. I'm assuming you sell chemicals, fertilizers, and then the service to apply them and do "other stuff" which would be activities. Why not put them all together in one product table? I used to sell computer hardware, software, and service. Whether it was a motherboard, an hour of training, or performing scheduled maintenance on a PC, it was all a "product" in my database. Unless you have a specific reason to split them into multiple tables... don't. But that's just my two cents. I also have other databases like my Work Order Seminar where I do split service and products into separate tables.
Richard Rost  @Reply  
          
5 years ago
The major benefit of using Access instead of some off-the-shelf software is you can build it however you like. Whatever works best for you and your business needs.
James Hopkins OP  @Reply  
     
5 years ago
Awesome, thank you guys for your time and help on this...
James Hopkins OP  @Reply  
     
5 years ago
Hey Guys, I am wondering if I have assigned a piece of out to an employee or crew. How can I do this correctly, Code, wise. To assign it In and Out to an Employee or Crew.
Richard Rost  @Reply  
          
5 years ago
Just another table with employee ID, in and out dates.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Manage Rental Inventory.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/8/2026 8:22:05 PM. PLT: 0s