Katlyn,
- Do you have Pipelines yet? During the webinar they said there was going to be a For Next loop. If it really will loop on a field [Quantity] creating child records, this is easy.
- PHP Script. This would be a simple script for someone familiar with the Quick Base API
On a related note what is your architecture for the Inventory Transaction? What do your tables look like to manage increasing and relieving the Inventory? Does your structure allow you to enter a record with a quantity and serial number at the same time? The downside is that you could have:
Record ID#: 1234
Quantity : 2
Serial Number: 654321
The system would claim that you have two parts with the same serial number. At year end when you have to do Inventory Adjustments after a count, you ability for those offsetting transactions would be very difficult.
Good luck and I hope the design question is helpful now while you are building instead 12 months into operations.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------