different drop down list in a field depending of the content of another field?

[eledal]

http://filemakertoday.com/com/images/smilies/wave.gif

Hello!

Is it possible to have different drop down list in a same field depending on the content of another field??

An example: I have different breeds of dogs and cats; I would like to have the drop down list of dogs breeds when in the species field is selected dog

Thank you for your helpsmiley-smile

[AHunter3]

Yep.

 

Read this thread especially beginning with post #4.

[eledal]

thank you very much....it works!!!smiley-laughing smiley-laughing smiley-laughing smiley-laughing

[eledal]

...what if the "category" field is a related one? I need a drop down list for cat vaccination and one for dog ones...but the species field is already in the patients field ...but if I put a related field in the category it doesn't work while it works if I write the name specie....but it becomes useless if I have to write the specie for each patient to have the right list...smiley-frown

[AHunter3]

I don't understand.

 

You already have "canine" or "feline" in a field (or else "dog" or "cat", whatever) in the local table? But when you try a relationship between that existing field and the Species field in the vaccination table your value list does not work? Whereas if you create a brand new field in your local table and use that instead it does work?

 

Well heck you're a regular member, post your file so I can see what you did.

[eledal]

here it is

thank you for your kind help

Maybe I've tried to make some changes from the previuos post but you can still see what I need

[Jack Rodgers]

Conditional value lists require that both fields be in the same table and both value lists determined from the contents of those fields, if I remember correctly.

[AHunter3]

You checked the checkbox for "related values only" but you did not specify the table that you're starting off from. See screen shot.

[eledal]

what I need is that when I create a new vaccination for a given patient, I can choose the kind of vaccination from a different drop down list depending on the specie. Usually I have the name of the specie specified in the patient layout, so I would recall it as a related field.

Is there a way to do that (even changing the way I have structured the database..)?? Or it is not possible at all??smiley-cry

Thank you

[AHunter3]

what you need is:

 

a) a SEPARATE table in which each record has at least these two fields: species and vaccination type. See this post -- download the example file. See how it is done with cuisines and entrees. Do the same with species and vaccination types.

 

b) Create a relationship between your current table and that new table, based on LocalTable::Species = NewTable::Species

 

c) Create a value list showing related values only of NewTable::Vaccination Type starting from LocalTable

 

EDIT: here, I figured out (finally) that your LocalTable is "Patienzi" so I did it for you --

[eledal]

thank you...it was just what I needed smiley-laughing ....I was trying to get the same result with a script (and I succeeded smiley-wink ) but this way is the straight one smiley-smile smiley-smile

thank you again