Stephen the Cook wrote: > Eurico Chagas Filho <> wrote: > >> Hi >> >> At one time when I had something similar, I opened a frame, in that >> frame I had three comboboxes, the user had to select in the first >> which would populate the second and so forth. >> You could have in addition a text box to enter a code. >> >> I used three tables. >> > > > It looks like it should come out of a single table > > I agree with Steve and the others for one table---otherwise you're hardwired into 'n' levels...in your case, 3. What happens if for whatever reason you wanted to go another level (to 4)? With one table, you're not limited at all using a parent-child hierarchy table relationship.
-- 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.
