A Value List that can Draw info from 2 diff Loc

[Joseph31]

Hello everyone..

I am haveing trouble figuing out how to make a value list (Its for a drop down list) draw its contents from two seperate sources...

I have insureds in one table and Sellers in another table... I would like to make a pull down list or drop down list that has both of these in them...

Is there anyway?

Joseph

[Andy Robo]

Hi Joseph

Is this screen shot helpful...? When you define value lists from a field you can set it to gather info from two fields...

[RalphL]

You will need to define the two value lists. You will need a new calculated text field Combined Value List that is a concatenation of two ValueListItems joined by a paragraph mark. Use this field for your value list.

I don't think you will be happy with this if you have many Insureds and Sellers.

[Andy Robo]

Oh yeah... duh, god I'm thick, and never used that option before too...

Ralph's thoughts are much more coherent....

just as well I haven't given up my day job!

A

[Joseph31]

ok, I understand...what would be your best suggestion for this case:

I have three tables:

Insureds, Sellers and Policies

On the policies table there are many fields...one is seller. this shows who is selling there policy (Name, address etc..). Most of the time it is the same as the insured but some times it is not... is there a way to make the seller auto fill in if a checkbox is checked with the insureds info?

[Damocles]

Joseph,

Would it work for you to have a button that says "Seller is Insured"? By the click of that button, you could activate a script that puts a check in the checkbox and automatically copies the insured's info. (probably several SetField commands) If you place the button directly behind the checkbox, the user will think they're just checking the box, when in fact they are pressing the button.

OR, (and this is just me rambling here) since you said that the seller is usually the insured, have the text fields automatically fill in when the insured's information is entered. Then, if the seller and the insured are different people, you could use the button to clear the seller's information and ask for manual entry into those fields.

IMHO, by requiring a checkbox to autofill the seller fields, you are adding a step into what should be your default action (i.e., adding seller as insured).

Sorry not to have a more concrete solution.

Paul

[Joseph31]

ok...great...I will give this a try..

Thank you

[RalphL]

I don't understand your setup but if you want to auto fill set it up in the field definition. Use the calcaulation option and use an IF or Case statement that fills if the check box is checked.

[Joseph31]

ok thanks