Data Model Question. Multiple table reference entries?
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?
This should be the second image...
You can see that I have tried to resolve this by adding a second table reference of Where Applied/Used.
@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.. :)
Thanks Mconneen. I have some other things to do today, but I will work on this later.
Mconneen, please email me the file you made. bruce at kieffer.us
Update: I set up a "Linked From" field rather than a "Table Reference" field, and so far that is working.
Nope, not working. I can only link the "Where Used" once.
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.