Value lists dependent on previous values...

[Calantha]

Hello,

I would like to know whether this is possible.

My "client" wishes to have three fields:

General Industry

Sub Industry

Job Title

General Industry with be a value list with say 5 values (i.e. Music, Film, TV etc).

Now, each value will have a sub industry value list (i.e. Music = Recording Studio, Mastering, Promotion, etc.)

Each Sub Industry has a corresponding value list (ie. Recording Studio = Runner, Assistant Engineer, Engineer).

He would like it so that when you choose the initial General Industry value, the value list for the Sub Industry field changes accordingly to match the General Industry value. So, if Music was chosen under General Industry, only the Value List for Music will be shown under Sub Industry, and only the Value List for the specified Sub Industry will be shown in the Job Title field.

Is this at all possible?

Thanks.

[VICH]

yes its called a conditional value list....if you search for it on here you will find plenty on it

i hope that gets you started in the right direction

[Calantha]

Thank you!

Starting to search right... now...!

[VICH]

if you can't find what your looking for i can probably help out more but at the moment i'm busy on my project, other wise i could set you up a sample file or something

[Calantha]

Yeah, I'm kind of confused and not really sure how to going about doing this.

I've read a lot about having to make tables out of everything, but... still confused on how it changes dependent on the other field.

[VICH]

first off do you understand making the different tables? as well as having to relate them

[Steven H. Blackwell]

Yes this is possible. You need a table for each category (just to follow normal form):

General Industry

Sub Industry

Job Title

Relationship between General Industry---

Relationship between Sub Industry--

When you define the value lists tell them to start their calculation from the appropriate relationship rather than taking all values.

When you select a value in Industry, only the related values from Sub Industry will appear in the second value list. When you then select a value in Sub Industry only the related values from Job Title will appear in the third value list.

HTH

Steven

[Calantha]

Yes, I currently have 4 tables in my database all related through "Faculty ID"....

[VICH]

well you will need a table with a record for each general industry and each possible sub industry for that general

so you need a table with a layout that if shown in list view looks like this:

music Recording Studio

music Mastering

music Promotion

film (sub industry)

film (sub industry)

film (sub industry)

tv (sub industry)

tv (sub industry)

tv (sub industry)

then you need a second table with all the sub industries and then their jobtitles

Recording Studio Runner

Recording Studio Assistant Engineer

Recording Studio Engineer

ect....

once you do that for everything you can define you lists off of those individual tables

when creating a value list choose "use values from field" and choose the General industry field and make sure you have include all values checked

then for the next list - sub indusry do the same thing except base it off of the sub industry feild and make sure show only related values is checked and make sure you and from there you keep repeating the process

[Calantha]

I am sorry, I am trying to do this but I am sure I am doing something extremely wrong here.

I have created three new tables:

General Industry

Sub Industry

Job Title

First off, do I have the relationship correct?

I have General Industry related to Sub Industry via the General Industry field.

I have Sub Industry related to Job Title via the Sub Industry field.

I have created records for each General Industry (Music, Film, Life, Sales, Internet, Misc).

My General Industry Value List works.

Within my Sub Industry layout I have a General Industry Field, and the Sub Industry field. I have chosen "Music" for the General Industry and entered one of the music Sub Industries in the Sub Industry field. I have done so for all sub industries of music.

I set my Sub Industry field to use values from field "Sub Industry" using only related values from General Industry??

It isn't working.

Should the Sub Industry be on the General Industry layout?

I know after I get this straight I will feel stupid because it is so easy, but right now my head is a brick wall!

[VICH]

email your database to me at the email in my profile i will fix it for you then you can see it done right and it will make more sense..thats how i learned i sent my database to one of admins of this site they fixed it for me then it made sense when i looked at it

Edited September 27, 2005 by Guest

[Calantha]

My email did not go through... :

[VICH]

send it to this email then [email protected] that is my personal email...my work email has been kinda fishy lately

[Calantha]

Thank you to all of those who helped. It now works and I've learned something new!