AnsweredAssumed Answered

Artist Inventory- adding function to create unique records for limited edition prints

Question asked by joemang1969 on Mar 25, 2013
Latest reply on Apr 7, 2013 by joemang1969

Title

Artist Inventory- adding function to create unique records for limited edition prints

Post

     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???

     Many thanks!

      

Outcomes