0

Table Look Up

If I have a table called 'members':

   Member Number   First Name Last Name 

        562323               Fred          Smith

        678944               Jane          Jones

 

and I want to upload a CSV file into another table called 'books'

    Member Number           Book Title                    Borrowed Date         Returned

         562323              Tale of Two Cities                   01/01/2018             1

         562323              1984                                     17/02/2018             0

         678944              Romeo and Juliet                    19/03/2018             0

If I have to upload a CSV every week into 'books' how do I get the new records in 'books' to automatically link to the 'members' table so that members book borrowing status can be viewed?

Thanks

3 replies

null
    • Andrew.1
    • 5 yrs ago
    • Reported - view

    Actually, I have found the instructions on how to do this.

    • ninox
    • 5 yrs ago
    • Reported - view

    Sorry, but where. I would like to use a lookup table.

     

    kgb

    • Emanuel_Neubert
    • 5 yrs ago
    • Reported - view

    Hi you can find it in our manual here:

    https://ninoxdb.de/en/manual/import-and-export/importing-linked-data

     

    Regards

Content aside

  • 5 yrs agoLast active
  • 3Replies
  • 1811Views