Steve Ellenoff wrote: > Hi guys- > > I'm curious what prevailing opinions you have about setting up repair > codes with multiple levels for the database. The repair codes I'm > specifically tasked to deal with currently have 3 levels such as: > > 5110 - Brakes > - 01 Front > 00 - Pad Change > 01 - Pad Change Cut Rotors > - 02 Rear > > 5120 - Towing > - 01 Accident > > > I was thinking of doing it in 1 table where sub codes link back to > the parent. Are there other, better ways to do this? This allows some > flexibility I belive, such as adding new levels if needed, but it > also might be kind of slow to parse a given code. > > As for the gui, my first thought was the list view to represent the > heiarchy, but the users responded that they "also" want a quick way > to enter the codes, so I was thinking of having a text box to allow > users to enter the number straight.. > > Has anyone dealt with this before, and have some suggestions or even > better, some shots of the UI you used? > > Thanks- > > Steve >
Hi Steve! I'd offer the idea of not only allowing numbers for the designated values, but also perhaps a SKU/Alias field where they can enter things like TOW to bring up TOWING. Expanding on that idea, you could have GROUPS for values, so using the same example, they could enter TOWING to bring up codes related to towing (if more than one--otherwise just using the only value on file rather than showing a list of one choice). Good luck! --Michael -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
