Hi all,
I'm working on a repair system. The who repair process have many steps like analyze,repair,clean,assemble,test and so on.And there maybe many units under repair but in different step.I would like to add an function in my main board so when I search by the repair id I could know which step is the unit in.
The only way I could think of is adding a field in every table and changing the filed to yes and the others to no when repair process changes.
But this seems a little bit compliacted, I'm not sure if there's a simple way to achieve this.
Any comments is appreciated.Thanks in advance.