3 Replies Latest reply on Nov 1, 2013 1:48 PM by philmodjunk

    Need advice on where to place a field....

    AdamHorne

      Title

      Need advice on where to place a field....

      Post

           I'm having trouble figuring out how to configure my database.  Here is an example of the information I'm trying to capture: https://www.evernote.com/shard/s22/sh/09dd57c4-c7d1-40d5-8eb0-d51856353f5c/5110b8b4a1003aa7b698d71a71e657c5
            
           I'm having trouble figuring out where the my ItemBarCode (GREEN ARROW) field plays into this database...
            
           As you see, in the Equipment table,  I have the ID (RED) and Description(BLUE) and a OrderLineItems join table. 
            
           I now need to keep track of the item's bar codes.  My initial thoughts were to add an inventory table to keep track of my overall total and add the barcode numbers to that table.  I also had the thought of adding it to OrderLineItems, but not every item has a barcode number and I do not want to create 5 portal rows for the same EquipmentID.
                                                                             
           I'm probably making this much more complicated than it needs to be...