> I think that whether you use one table or three the processing overhead will > be the same - you will still need several seeks which will take the same > amount of time whether they are on one table or three. A single table will > give you more flexibility and will be easier if the user wants to enter a > code directly. > > Can't help on the Gui I'm afraid. > > John Weller > 01380 723235 > 07976 393631
Google for recursive or hierarchical queries and use a tree view. Provide a search on the part description. Give every part a code the user can enter. Mike Yearwood _______________________________________________ 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.
