look up fileds

[brothertse2008]

i want to arrange my menu options in a tree like structure. Its for a fault logging system so for example we select the softwar option then it should display options relating to it, and the same for the hardware option.

Do i need to use filters for this ? Ive tried to do it for a few days but cant seem to get it to work

help please

 

[pbaldy]

Are you talking about this kind of thing?

http://www.baldyweb.com/CascadingCombo.htm

 

[brothertse2008]

i think so. Basicaly the system has 3 levels and navigates like a tree structure. So the options that appear on level 2 depend on the level 1 selection. and level 3 options depend on level 2 options. do i need to create a table for each level then use filters or something like that ?

 

[pbaldy]

Well, I'd use one of the 2 techniques I demonstrated. Depending on your specifics, you may be able to do it all in 1 table, but the technique doesn't really change either way.

 

[brothertse2008]

could you be a littel more specific ?im new to access.

do i need to set up seperate tables for the levels required? or have 1 table with each field labeled as a level

NOTE: were not doing this in code we are using the built in propertie functions and menu options

 

[pbaldy]

More specific about what? That link has a sample database demonstrating 2 different techniques. It also has a table with its data, so you can see what that looks like.

 

[brothertse2008]

the zip file is invalid

 

[pbaldy]

Curious; many people have downloaded it fine, and I just tested and had no problem.

 

[brothertse2008]

Error message :

CANNOT COMPLETE THE COMPRESSED (ZIPPED) FOLDERS EXTRACTION WIZARD

the compressed (zipped) folder is empty:

before you can extract files you must copy files to this compressed (zipped) folder

 

[pbaldy]

Not sure what to tell you, as nobody else has had a problem. Perhaps you have a firewall blocking it? In any case, the guts of the methods are posted on the page.

 

[Rabbie]

Just to say I downloaded the Zip file and it worked perfectly