0

Please explain Many-to-Many relationships and One-to-Self relationships in Ninox!

I've been looking about everywhere, and every explanation either skips the last steps of *how* to actually build the DB in Ninox, OR says they will offer a one-size-fits-all solution, opnly to have blatant shortcomings.

I'll first explain what I need:

I'm building a Research Database, in which all possible (known linguistic and visual) Stylistic Devices are documented.

To this effect I need a "SD" (Stylistic Device) table with fields "SD Name", "SD Description", etc…

One-to-Self Relationships

I need to be able to add crossreferences ("Related SD"), as in the SD "Alliteration" that is related to "Consonance", "Rhyme" and "Acrostichon". But these crossreferences shouldn't be exclusive: Every "SD" can have any number of "Related SD", who can themselves have any number of OTHER "Related SD"

Many-to-Many relationships

In addition to this, I need to curate a number of "fragments" (of literary works), that have their own "Frag DB".

The SD DB and the Fragment DB need to be interlinked: Every SD can have many illustrative Fragments, but every Fragment, can be illustrative of any number of SDs.

I need every SD to have "examples"/fragments, who *automatically* have the possible SD noted.

 

Please help! I have found some solutions suggesting I'd need a "Junction Table" to pull these off.

Do I need 2 junction tables? Please detail the building steps needed!

Thx in advance!

8 replies

null
    • carabooks
    • 3 yrs ago
    • Reported - view

    I think this question is a technical way of asking what I also need to know - - I'm a real beginner at this, so apologies for my restating the question in basic language. I need my Projects table to be linked to my Invoices-Payments table in such a way that any one project can be linked to two or more invoices or payments (for example if it's being paid off in installments). But all I can manage to do is a one-to-one link, so a project linked to the initial invoice can't subsequently be liked to a paym

    ent or later invoice. Can any one help, in simple language? And if this is a different question, please let me know and I'll post anew. Thank you!

    • Sean
    • 3 yrs ago
    • Reported - view
    • Vinod_Kumar
    • 3 yrs ago
    • Reported - view

    +91-9876425548 ☼husband solution☼ Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Divorce Problem Solution in Lucknow

    • Vinod_Kumar
    • 3 yrs ago
    • Reported - view

    +91-9876425548 ☼husband solution☼ Divorce and separation in Lucknow+91-9876425548 ☼husband solution☼ Divorce and separation in Lucknow+91-9876425548 ☼husband solution☼ Divorce and separation in Lucknow+91-9876425548 ☼husband solution☼ Divorce and separation in Lucknow+91-9876425548 ☼husband solution☼ Divorce and separation in Lucknow+91-9876425548 ☼husband solution☼ Divorce and separation in Lucknow+91-9876425548 ☼husband solution☼ Divorce and separation in Lucknow

    • Vinod_Kumar
    • 3 yrs ago
    • Reported - view

    +91-9876425548 ☼husband solution☼ Husband husband Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Husband husband Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Husband husband Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Husband husband Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Husband husband Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Husband husband Divorce Problem Solution in Lucknow+91-9876425548 ☼husband solution☼ Husband husband Divorce Problem Solution in Lucknow

    • Vinod_Kumar
    • 3 yrs ago
    • Reported - view

    +91-9876425548★ divorce solution★ Most Powerful Law Of attraction in Kanpur+91-9876425548★ divorce solution★ Most Powerful Law Of attraction in Kanpur+91-9876425548★ divorce solution★ Most Powerful Law Of attraction in Kanpur+91-9876425548★ divorce solution★ Most Powerful Law Of attraction in Kanpur+91-9876425548★ divorce solution★ Most Powerful Law Of attraction in Kanpur+91-9876425548★ divorce solution★ Most Powerful Law Of attraction in Kanpur+91-9876425548★ divorce solution★ Most Powerful Law Of attraction in Kanpur+91-9876425548★ divorce solution★ Most Powerful Law Of attraction in Kanpur+91-9876425548★ divorce solution★ Most Powerful Law Of attraction in Kanpur

    • Vinod_Kumar
    • 3 yrs ago
    • Reported - view

    ★get love back★+91-9876425548 Solution Of Black Magic Effect in Bhopal★get love back★+91-9876425548 Solution Of Black Magic Effect in Bhopal★get love back★+91-9876425548 Solution Of Black Magic Effect in Bhopal★get love back★+91-9876425548 Solution Of Black Magic Effect in Bhopal★get love back★+91-9876425548 Solution Of Black Magic Effect in Bhopal★get love back★+91-9876425548 Solution Of Black Magic Effect in Bhopal★get love back★+91-9876425548 Solution Of Black Magic Effect in Bhopal★get love back★+91-9876425548 Solution Of Black Magic Effect in Bhopal

    • carabooks
    • 3 yrs ago
    • Reported - view

    Thank you, @Sean, this looks very helpful.

Content aside

  • 3 yrs agoLast active
  • 8Replies
  • 835Views