I have six Hirarichal tables linked as (one to many relationship), I want to create a form with six drop down lists,
First table contains all data in the list box,
second list box should retrieve records on behalf of selection of first list box (accept the selected value and show matching records in second table and so on) upto six leve.
It is a basically Heads upto six level with one to many relationships. (A Budget Database)
Hope to hear y people soon.