Similar to VMRS right? Separate, as has been suggested, makes it more flexible... Depends upon if you want your users to "build" their own code(s) or not. If not stuff all the different combinations in one table. Might make thema a little lengthy... HTH
> Date: Fri, 23 Feb 2007 17:52:50 -0500> To: [EMAIL PROTECTED]> From: [EMAIL > PROTECTED]> Subject: Repair Codes Database & GUI design> > 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> > > > > > _______________________________________________> 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.> > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
