0

Creating view with fields from multiple tables

Novice user question: I need to create views (reports, invoices) that allow me to draw data from multiple tables -  e.g. I have three tables, Vendors, Expenses, and Clients, and I need to run quarterly reports that allow me to show individual expenses per client and individual expenses per vendor. Is there a way to do this? I've searched the manual and forum but can't seem to find what I need. Thank you in advance!

4 replies

null
    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    when creating your forms etc

    in the pick list on the left you will see a list of the fields for your current table

    also you will see a heading(s) for the name of any related tables.

    click this heading and it will further expand to give you the field names from that related table to include on your forms etc.

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    Just to add - you have more felxibility with this re forms /reports

    in terms of table views - options are limited

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    Also not sure if you have seen the online manual re views - see link

    https://ninox.com/en/manual/tables/views

    • carabooks
    • 3 yrs ago
    • Reported - view

    Thank you, Mel - - I hadn't found that section of the manual and will now work with it. I appreciate your help.

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 609Views