I’m trying to build an inventory management system and I’d like to rollup multiple components into a kit. I imagine I would do this via Kits and Components tables. What I would like to have happen is that when I move (I intend to use the Kanban view) a kit into the Checked Out state that all the components would, likewise, have the same Status applied to them.
I could do this via the API but without callbacks (argh!) it wouldn’t be real-time like I want it to be.
I know there’s the Lookup field where I can lookup the Status of the parent record but this has a big limitation in that the result doesn’t take the format of the parent’s field. In other words, the Lookup field is just a text field instead of a Single Select which, in turn, means I can’t view Components with a Kanban view.