I have a table(s) with layered codes and subcodes in them. Here's a sample:
http://www.angelfire.com/pw/access/Nested.ppt
I need to be able to have a QUICK, efficient way of displaying this information, starting off with displaying the Level 1 code. If a user double clicks that line item, I want all the level 2's to come out, with an indicator if they have children codes.
It should be collapsable, Like this:
http://www.angelfire.com/pw/access/Nested2.ppt
I could probably implement this without help, but I'm sure it wouldn't be as efficient/fast as it could be, with just raw coding. The infrastructure/syntax of Access is not familiar to me...anyone see the best way to do this? (linked lists, arrays?)
Thanks.
http://www.angelfire.com/pw/access/Nested.ppt
I need to be able to have a QUICK, efficient way of displaying this information, starting off with displaying the Level 1 code. If a user double clicks that line item, I want all the level 2's to come out, with an indicator if they have children codes.
It should be collapsable, Like this:
http://www.angelfire.com/pw/access/Nested2.ppt
I could probably implement this without help, but I'm sure it wouldn't be as efficient/fast as it could be, with just raw coding. The infrastructure/syntax of Access is not familiar to me...anyone see the best way to do this? (linked lists, arrays?)
Thanks.