0

How to connect this table

Ninix gurus,

Just when you think you now have your app ready, yet..... it turns out there is another catch.
In my database for musical works, the main table is: Titles.
From there you can choose on the form for the composer, lyricist, arranger from the relevant tables, among others.
But there is also a table books. This is a table that lists what books I have on either composers, or titles.  This table has the fields: book title, composer related, title related etc. . Now I am looking for the way to: when you create a new title that on the title form comes a list of books related to that particular title. Or, after the composer is chosen on the title form, that a listing of books related to that composer will automatically appear.
I have done a lot of puzzling, but no results yet. Can anyone give me a push?

 

Thanks

Rob

1 reply

null
    • Daniel_Berrow
    • 1 yr ago
    • Reported - view

    You can have a couple of views, of which one is looking at the composer as a comparison 

    let t := this;
    select books[composer = t.composer]

    and you can do a similar thing with titles, but may need to use the contains function instead of simply =, it depends what your data looks like

    Hope this helps, but if not can you explain a bit more what your issue is with some pictures of the data?

Login to reply

Content aside

  • 1 yr agoLast active
  • 1Replies
  • 44Views
  • 2 Following