I am trying to set up a database for our inventory. We are a printshop and need to keep track of multiple version of on item.These are posters each printed in an edition of, lets say 20. So at the moment i have the info related to a poster like title or size.But now i need to have more information about each of the 20 in an edition. For example : number 5 of 20 of the poster with the title 'XYZ' was sold to 'NAME' or is in location 'X'
Now my question is how do i assign information to one specific variation of an item.
I am very thankful for any tips