I am developing a yii inventory system but I have one challenge,
I need when user select a particular item from the database using auto complete a flex grid pops up with suggestion from the type in character, then the user adds value (lets say quantity on the item)
And upon click on next the data is submitted to the database
that would be a lot of custom coding. you can use a autocomplete / select2 (i like this better) to search a grid view and do inline editing of the grid that automatically saves.
I do something similar in my inventory / asset management system i created. Good luck on this i’ve spent the last 2 years working on it and it finally ships to customers on aug 11. So i know your pain in creating this type of system.