Data Model Question. Multiple table reference entries?

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

And from Paint.. it looks like.. 

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!

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.

"give a man a fish and you feed him for a day; teach aman to fish and you feed him for a lifetime." .... Laozi