I am trying to create a DB which will allow our warehouse staff to select from a predefined list of items ie. desks each of which has assigned values including weight, £ value, etc. When they select an item i need the relevent fields on the inventory to auto populate with the relevant data ie. they select 1200mm straight desk from the list and the £ Value and Weight fields are automatically updated.