Pull field value based on dropdown selection

[topazmedia]

Hi there,

 

I have a contact database table as part of a larger solution that I am building and am trying to achieve the following:

 

I have a dropdown box with "Business" and "Individual" and a field called "display name". I am trying to make a calculation that pulls either the business name or an individuals name based on what is selected in the dropdown box.

 

Does anyone have any ideas? I have tried a few variations to no avail.

 

Best regards,

 

Tim

[Lee Smith]

Hi Tim and welcome to the forum,

 

Don’t you mean drop-down list or menu

What’s the purpose of the calculation result?

It seems unusual that you would have a drop-down menu or list again and need to calculation field too. Unless, you were going to display this  calculation result in a different  field or Table Occurrence.

 

Lee

[comment]

I have a dropdown box with "Business" and "Individual" and a field called "display name". I am trying to make a calculation that pulls either the business name or an individuals name based on what is selected in the dropdown box.

 

Does anyone have any ideas? I have tried a few variations to no avail.

 

I am not sure why you're having problems with this - it seems pretty trivial. Make Display_Name a calculation field (result is Text) =

Case ( Type = "Business" ; Business_Name ; Individuals_Name )

where Type is the drop-down field.

 

 

 

If this is for display only, you could simply put both source fields on top of each other.

[topazmedia]

Hi Lee & Comment,

 

Thank you both very much for your responses to my post. I have adopted Comments solution and thats doing exactly what I need. 

 

Best regards,

 

Tim