Hi,

I have 3 tables and I want to make a view with several fields of the 3 tables.

In Microsoft Access I make a query with this 3 tables and I select the fields that I need and there’s my new table (or view).

How can I do such a query in Ninox?

 

These are the 3 tables.

Contractor :

-              VAT number

-              Contractor name

-              Reference

Gebruiker :

-              Identification

-              User name

-              VAT number

Registraties_Detail :

-              Date registration

-              Identification

-              TAG

-              Amount

-              Receipt number

 

I would now like to create a query (View) containing the following fields:

-              VAT number

-              Contractor name

-              Reference

-              Date registration

-              Identification

-              User name

-              TAG

-              Amount

-              Receipt number

 

How am I supposed to realize this?

 

Tx

 

Regards

 

Michel