Does anyone have a suggestion on how to create a lookup in order to create new records?
My use case is as such: Purchase Order system application. However, I want the ordering party to be able to choose a "package" consisting of two choices - System & Size. Once they've chosen this 'package,' I would like to look up the system-size combo and insert all the line items associated with this combo record. Ideally, I envisioned a table with unique identifier (system-size), product model, type, cost.
Then when the ordering party selected the combo (system-size), we could look up all products matching the combo and add them to the order record's line items (children).
Any thoughts out there?
Thank you so much for your input!