select-able conditional value list

[johnmarcel]

I am trying to make a list that is select-able and the values are base on another field. I have tried the following but for some reason the values are all or none.

If(at_client_sn=814; List(at_department; 
"ALBANY MEDICAL CLINIC";
"ALBANY SURGICAL ASSOC";
"ALBANY SURGICAL CENTER";
"ELM ST. PROFESSIONAL";
"EYECARE ASSOC";
"GEARY ST. CLINIC";
"INTERCOMMUNITY HEALTH";
"LEBANON COMM. HOSPITAL";
"LEBANON IMAGING DEPT.";
"LEBANON SURGICAL ASSOC.";
"MAIN ST. CLINIC";
"N. LINCOLN MEDICAL PLAZA";
"PHYSICIANS REF. NETWORK";
"REBOUND PHYSICAL THERAPY";
"SAMARITAN ADMITTING";
"SAMARITAN ENDOCRINOLOGY";
"SAMARITAN HEMATOLOGY";
"SAMARITAN INTERNAL";
"SAMARITAN NEURO SURGERY";
"SAMARITAN NUCLEAR MED.";
"SAMARITAN OB/GYN";
"SAMARITAN OB/GYN SURGICAL";
"SAMARITAN ORTHOPEDICS";
"SAMARITAN PEDIATRICS";
"SAMARITAN PLASTIC SURGERY";
"SAMARITAN PRE-OP";
"SAMARITAN RADIOLOGY";
"SAMARITAN RHEUMATOLOGY";
"SAMARITAN SPORTS MED.";
"SAMARITAN SURGICAL SPEC.";
"SAMARITAN UROLOGY"
))

[Rick Whitelaw]

I'm not sure I understand what you're trying but the List function has nothing to do with value lists.

[johnmarcel]

 

I have a department field that  has around 30 different departments. When the client field has the correct client in it i want the list to be available. but, i want to be able to select the correct department from a list. a drop down list will not work due to the fact i have over 2000 clients. 

[dwdata]

I think I follow what you need. Correct me if I am wrong. Do you only need a field with a full down menu of the the Departments listed in ASC order? If so:

Define a new table called "Departments" with one field called Department_Name (Text Result).

Populate the table with your Departments - one record per Department

Define a Value List called "Departments" base it on a field value Department::Department_Name

Bask on your "client" layout, you can use that value list for the Department field.

Doe that work for you? If not, please let us know.

 

[johnmarcel]

I tried that. it works great when that particular client is selected but, when another client is selected the department field is not able to be written in. i am probably missing some step.

 

 

[dwdata]

I tried that. it works great when that particular client is selected but, when another client is selected the department field is not able to be written in. i am probably missing some step.

Yup. Tell ya what, will you post a sample file (with sample data) with what you did and a few notes (in red text) on the layout of what you are expecting to see? I will be glad to take a look at it and resolve the issue. It is probably something simple.

Thanks!

Edited October 9, 2015 by dwdata

[Lee Smith]

Hi Don,

I was going to point at conditional value lists, but I’m not sure the file is normalized for that. A sample of the file will be helpful to see his schema.

@Johnmarcel - be sure to zip your file 

Lee

[johnmarcel]

thanks for your input but, The solution I think I am going to go with is to make a separate drop down field that will only be visible when that client is selected.

[Lee Smith]

Ok, post your file when you get stuck. 

[dwdata]

Ah! I see. So... only show the values if there is a valid client selected.

Attached is a file with a method to get that effect. It uses a Value list based on a relationship. The left side of the relationship is a calculation that checks that a client has been selected. If not, there is no relationship to Depts and they are NOT visible ELSE Depts are visible to be selected.

Hope this helps!

client_depts.zip

[johnmarcel]

Thanks I will take a look at the file.

Yeah I tried that but, the problem is that the pop-up has to change dependent upon the client selected. on 90% of the clients their would be no pop-up but the department field would need to be able to be manually entered data into.

[dwdata]

What determines if a client get a list of departments or not?

What version of FileMaker are you working with? FileMaker 12 Adv. like your profile suggests?  Base on this, I will give my advise.

Thanks!