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
-
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!
-
Here are a couple of links that should help...
http://software.kirknessassociates.com/blog_files/a4c45ec917dd812368f9d773eb1c27a1-39.html
-
+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
-
+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
-
+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
-
+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
-
★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
-
Thank you, @Sean, this looks very helpful.
Content aside
- 4 yrs agoLast active
- 8Replies
- 858Views