0

How can I structure the extraction of inventory data?

I have an inventory database. My products are recorded in two tables based on whether they are opened or unopened. (Unopened: whole boxes; Opened: whole boxes * units). Now I want to count the inventory and display it in a line chart, but Ninox doesn't seem to support extracting data from two tables and displaying it in one line chart. How can I structure the extraction of this inventory data?

 

Thank you for your reply.

4 replies

null
    • Fred
    • 2 mths ago
    • Reported - view

    Can you merge the two tables together?

    It seems like the data would be exactly the same except for one or two fields.

    Otherwise you would have to create a button that would copy the data you want into a temporary table to use to make the charts.

      • gold_cat
      • 2 mths ago
      • Reported - view

      Based on your response, it seems that it is more convenient to extract data from only one table. Since I have been using this database for a while, I need to adjust the previous thousands of records, which is a big project.

      • Fred
      • 2 mths ago
      • Reported - view

      The second method is also quite doable. I am not talking about copying each record from the two tables, but a summary of the data from the two tables.

      For example, you probably want to see what is happening on a monthly basis. In your new chart table you can have the twelve months as records then have fields that hold data you want, like Unopened inventory or Opened inventory or Monthly Sold etc.

      Then your button would do the math and put the data into the appropriate place and then your charts would show the data you want.

      • gold_cat
      • 2 mths ago
      • Reported - view

       Thank you Fred, I still plan to solve this problem and merge them together.

Login to reply

Content aside

  • Status Answered
  • 2 mths agoLast active
  • 4Replies
  • 32Views
  • 2 Following