1 Reply Latest reply on Feb 7, 2013 11:50 AM by philmodjunk

    Database Relationship Advise

    ericjlindholm

      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