AnsweredAssumed Answered

Populating an order with a list of pre-defined parts?

Question asked by pinchvalve on Jun 17, 2014
Latest reply on Jun 17, 2014 by philmodjunk

Title

Populating an order with a list of pre-defined parts?

Post

     I have a database that users build an order by selecting parts from a related table of available parts.  The users have mentioned that 3 or 4 markets have a set group of parts that are included in every order.  They would to have a button where they could add these groups with a single click.  Before I start working on this, I thought I would ask if anyone had built something similar or had a best practice on doing this?  

     My initial thought is to add a new "group code" field to the Parts table.  That would allow me to identify individual parts as belonging to a certain group.  Then build a script that searches for that code, grabs all of the records, then pastes them into the current order.  Sounds simple, but I have to figure out the steps.  

Outcomes