0

Many to Many Relationships

Hopefully this is an easy fix.

I have set up two tables: "Work" & "Drawings"

I have managed to link entries in Drawings so they can be linked to an entry in Work.

I can have as many drawing entries linked to an entry in Work, but when I came to add another entry in my Work table, I was unable to select an existing entry in Drawing as it had been inextricably linked to a previous Work entry.

The problem I have is I create an entry in Work and link a drawing.

My client will sometimes come back for alterations a few days or weeks later to the drawing so it becomes another new entry in Work. As I have already linked the drawing to the first Work activity I am now unable to link it to the new Work activity

Does this mean I need to have Many to Many Relationship?

I think I read somewhere that I am unable to do this in Ninox without adding another table or some such workaround.

ANy help would be much appreciated.

4 replies

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    @David.. One strategy is to create an association table between Work and Drawings. 

    association

    For ease of use, you will want to manage the "WorkDrawings" association table as a hidden table.. and build the associations as you add drawings to your Work items. 

    Check out NinoxUS .. I believe Andy has a tutorial on this. 

    • davidw
    • 4 yrs ago
    • Reported - view

    @Mconneen,

    Thanks for the response, I will check out his site and see if I can understand the tutorial ;)

    Really appreciate the help you are giving me while I am getting to grips with all these concepts.

    • Database Consultant
    • Kirkness_Associates_Ju
    • 4 yrs ago
    • Reported - view

    I have also written a couple of blog posts about this topic - they are availabe on my new blog / forum site dedicated to online databases:

    https://www.onlinedatabase.expert/post/relating-to-relational-databases-part-1 

     

    https://www.onlinedatabase.expert/post/relating-to-relational-databases-part-2

     

    There are other Ninox related articles there as well - all welcome!!

    • Mconneen
    • 4 yrs ago
    • Reported - view

    Sorry Julian .. I forgot about your blog.. Yes.. those are informative as well!  Thanks for the efforts!   Looks like David has the classic "associative" for a many to many... That said.. In his use case.. He could accomplish the same by opening another "task" against the "project" that developed the drawing. :) 

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 2136Views