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

8 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
      • 1 mth 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
      • 1 mth ago
      • Reported - view

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

      • pascalp
      • 1 mth ago
      • Reported - view

       Thank you, Fred, you are precious.

      • pascalp
      • 1 mth ago
      • Reported - view

      If I understand the documentation correctly, I have to set up the relationship first. So I follow the tutorial:

       

      1. Open the Offers and invoices database.

      2. Open the Invoices table.

      3. Click the wrench icon in the top-right corner to enable edit mode.

      4. Click the drop-down arrow next to the gear icon on the left and select Edit fields from the dropdown to access the table settings.

      5. In the table settings, select the All databases in current workspace checkbox.

      And here is the problem: I do not see All databases in current workspace. Maybe this is not available for iPad?

      • Fred
      • 1 mth ago
      • Reported - view

      It is only available for those with private cloud or on-premise.

      • pascalp
      • 1 mth ago
      • Reported - view

       Ah, ok. Too bad. I use Ninox with iCloud.

Login to reply

Content aside

  • 1 mth agoLast active
  • 8Replies
  • 1135Views
  • 2 Following