0

Show two tables in one view

Hi there - has any body tried to do this and how will it be done ?

 

The case is that I have a table for purchases (Danish name "Indkøb") An a table for Sales (Danish "Salg"), and I want to show them in the same view so I can make a graph showing the progress in the inventory for each article.

I guess I have to create a Phantom table containing fields Fram both tables - the inventory I created is taken from the official template in Ninox with some changes which suits my needs, but the data structure is quite the same. 

rgds

Leo

5 replies

null
    • szormpas
    • 12 hrs ago
    • Reported - view

     Hi, could you create a small demo database with just the two tables and the type of relationship between them?

      • Leo_Woer
      • 12 hrs ago
      • Reported - view

       

      Hi Sotirios, it will be be complicated only to send you the two tables, so I provide you with the whole DB

      And as stated it is very alike to the official template, but with som changes here and there, and off course translated to Danish.

      Thanks for your interest - hope you can understand the DB ebven if it is Danish,

      rgds

      Leo

      Lagerstyring.ninox
      • szormpas
      • 11 hrs ago
      • Reported - view

        Hi,

      The relationship between the 'Indkob' and 'Salg' tables is N:N via the '3_Varer' table.

      I've created a view in your dashboard for the table "3_Varer". This gives you access to both the 'Indkob' and 'Salg' tables.

      Is this what you are looking for?

      Lagerstyring_v1.ninox
      • Leo_Woer
      • 11 hrs ago
      • Reported - view

       

      Hi Sotirios

      No this is exactly what I was able to do myself - the view must be one view to be able to create a graph, which shows the development in both purchases and sales in the same graph.

      That is why I think I have to create a phantom database. Anyway thanks a lot until now.

      rgds

      Leo

      • szormpas
      • 9 hrs ago
      • Reported - view

        Hi,

      I haven't used Ninox native charts much myself. But if you want to be able to create a dataset and present it with nice charts in a way that gives you lots of freedom, you might want to think about integrating an external library like eCharts.

      You'll find some useful info in the "Statistics" section of the Dashboard Template project.

Login to reply

Content aside

  • 9 hrs agoLast active
  • 5Replies
  • 37Views
  • 2 Following