Calculation instead of Script

Posted on 2011-10-24
Last Modified: 2012-05-12
I would like to know how to do the following as a calculation  :
Basdically I  have 3 Tables
   Product ID
   Product Category
   Quantity to Be Produced
   UNITS per Hour (Production Rate Per Product Category per Hour)
   fk Product Category
    Production ID
     Hours to Produce
     Day Of Production
Hours to Produce Field to evaluate   a)The Product Category  of the Product Code then, b)Get the Rate Of Production (For this particular Category) and c) Divide the Quantity to be Produced by the Rate Of Production to give the number of Hours it will take to Produce this product on the selected Day Of Production.
Many Thanks
Question by:Krisraychris
    1 Comment
    LVL 1

    Accepted Solution

    You are going to need one more table where you assign the production day to a specific product you want to make that day, or you can assume you only make one product and that all the available production days are for the one product.

    The next thing you want to do is create a script that looks at the available days table and assigns the product to the next day available until you consume the available capacity with the available days. So you want to add a field to the Product data table to hold the "Quantity assigned to future production capacity"

    Every time you consume some of your capacity you update the product data until your required quantity is equal to your Quantity assigned to future production field.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now