0

How can I link 2 separate database?

How can I link 2 separate database?

For instance one data base with data from customer and another with time and labour. 

Cheers

4 replies

null
    • Fred
    • 3 yrs ago
    • Reported - view

    The easiest way would be to create a reference field in your table that tracks time and labor to your customer table. It will default name the new field to your customer table name but you can rename whatever you want.

     

    now you can select a customer and Ninox will link it to the record in your second table. 

    if you go back to your customer table you will see a new View element that will show all records linked to it in the second table. 

    good luck. 

    • Mconneen
    • 3 yrs ago
    • Reported - view

    @Mario,

    If the technical constraint is that they MUST be two separate DATABASES (not tables within the same database) ... Two things come to mind.. 
    1.  Use the REST/API to query across the databases.  You must be on the Ninox (or private) cloud..
    2.  Use an integration software, like Integromat or something similar.  

    That said.. I question the constraint.  In most cases.. this is because you want one group of people to only see their time cards.. and another group of people to see customers, projects, etc.  You can do that through user security.

      • pascalp
      • 9 hrs ago
      • Reported - view

       It makes sense to me. I do it with Filemaker. Because I manage various companies. But the cities, countries, etc, are the same. And a customer of company A may also be a customer of B and C. If his data changes (for example, if he moves house), I don't need to update each of the databases. That's why if there was a simple solution to implement with Ninox, I'd be delighted.

      • Fred
      • 8 hrs ago
      • Reported - view

      Now there is do as database for private cloud or on-prem DBs.

Login to reply

Content aside

  • 8 hrs agoLast active
  • 4Replies
  • 1067Views
  • 2 Following