Populating an order with a list of pre-defined parts?
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.