Artist Inventory- adding function to create unique records for limited edition prints
I'm designing a database to track inventory and sales of artworks
I would like to create a script or function that will duplicate the records and add them as unique items.
For instance I have an edition of 30 prints and they need to be numbered 1/30 2/30 3/30 and so on... they are Identical pieces of art but will each be sold seperately or loaned or gifted etc...
How can I enter the information for the edition only 1 time and create sequential records?
I'm producing editions of 250 and 500 so I need to identify each individual print and its collector without the hassle of entering 500 individual items to my inventory....is there a scipt or button funtion I could create that would serve this purpose???