6 Replies Latest reply on Aug 25, 2016 6:36 AM by Tom_Droz

    Copy data to table with muliple options

    Tom_Droz

      FM14 Windows

       

      I have a solution where I have a "Shop" table and layout based on "Shop".

       

      My customers would like to select common "Shop" billing that they could select from that would then prepopulate the "Shop" record

       

      So if they pick option "1" maybe 20 fields would populate

      .Option "2" maybe 35 Fields different fields and different data

       

      They would want to create their options on the go and the options might change from time to time.

       

      Anyone do something like this that they feel is a good solution?

       

      My 1st thought was to duplicate the "Shop" table as "OptionShop" and recreate the layout from the original, then have them create as many Options (each its own record) as they want in the "OptionShop" layout.  Then script a copy from the "OptionShop" to the "Shop" when needed.  Another Idea was to link the 2 tables with each field having a "Lookup" that could be refreshed by script

       

      There are about 200 fields and it seems like a lot of scripting.

       

      Any other creative solutions?


      Thanks

      Tom.