Forum Discussion
If I am correctly, understanding what you were trying to accomplish, then there is my favorite technique called User Focus which could make this work.
The user would launch off a button on the pull list items. The button would populate the User Focus record for the current user with the Focus master inventory record I'd ie, the one that the pull list is a child of.
That would put the master item in focus and hence all it's children Master Subs, via a lookup and then via a summary field would put all the sub inventory items in focus which belong to any Master Sub which is in focus.
Then the user would be landed in a grid edit form which is driven by a dedicated form to limit the drop down choices for Sub items which are in Focus.
If that approach sounds like it could work then we could either very slowly try to work through the steps to do this via this forum or else get on a consulting call for an hour and knock it off together.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Ah, amazing, thank you Mark! Knocking it out in an hour sounds great. I'll PM you to schedule?
------------------------------
Elena Larrabee
------------------------------
- Gary12 years agoQrew Assistant Captain
I was really hoping you'd hash it out here. I just made popcorn.
------------------------------
gary
------------------------------- MarkShnier__You2 years ago
Qrew Legend
I will post back next week after our meeting:)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------