Data Model Question. Multiple table reference entries?

Ninox Profile

I've created a paint database for paints applied in or on my house. I made two tables; one for the paint info, and one for the paint location. Some paint colors are used in more than one place. Is there a way to set up the table reference so I can apply the paint to multiple locations?

Screen Shot 2019-07-13 at 9.08.21 AM

Screen Shot 2019-07-13 at 9.08.21 AM

Ninox Profile

This should be the second image...

Screen Shot 2019-07-13 at 9.08.36 AM

Ninox Profile

You can see that I have tried to resolve this by adding a second table reference of Where Applied/Used.

Ninox Profile

@Mr K... First.. Thank you for using Benjamin Moore paints.   My wife's Uncle managed a manfuacturing plant outside of Chicago, IL.. :)   He has since retired, so continued support helps his pension.. :)   

You could create a Many to Many relationship (A Paint may be used in many rooms.. and a room may have many paints) ...  So I created a table called Paint Location ..  

Many To Many

And from Paint.. it looks like.. 

paint

You could also add a "constraint" to prevent you from adding the same paint color to the same location more than once.. :) 

Happy Ninox-ing!

Ninox Profile

Thanks Mconneen. I have some other things to do today, but I will work on this later.

Ninox Profile

Mconneen, please email me the file you made. bruce at kieffer.us

Ninox Profile

Update: I set up a "Linked From" field rather than a "Table Reference" field, and so far that is working.

Ninox Profile

Screen Shot 2019-07-13 at 7.08.01 PM

Ninox Profile

Nope, not working. I can only link the "Where Used" once.

Ninox Profile

Mr. K.,

You need to create a new one table inbetween Paint table and Where Applied table. So delete the reference you have just created and create a new table, let's say Paint Appliance, where you should add at least two fields (Create table reference): ➞ Paint and ➞ Where Applied. You may add there a few fields about your painting conditions like Painting Date, Painting Method, Paintig Person, Painting Memos etc.

1 2
Reply