Many to Many Relationships
D

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.

Ninox Profile

@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. 

 

D

@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.

Ninox Profile

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!!

Ninox Profile

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. :) 

Reply