AnsweredAssumed Answered

Database Relationship Advise

Question asked by ericjlindholm on Feb 7, 2013
Latest reply on Feb 7, 2013 by philmodjunk

Title

Database Relationship Advise

Post

     This a basic layout of what my system looks like now.  I have Events containing many Equipment lists, containging many line items.  Events only has one client and equipment lists can only have one venue.  I am wondering if I could eleminate the EQuipment list table and keep all those records in line items for easier duplication etc.  I would just  cant figure out how to make it so that if I change the venue on one EQ list, it would change all the associated line items to the new venue.  OR is what I have better? 

scan.jpg

Outcomes