To handle this with JavaScript

1. Create a few single line fields that the lookup will populate with values for race, gender, day, etc.
2. In the Advanced tab, next to CSS class give each field appropriate classes (race class for Race field, gender class for Gender field, day class for Day field. Because each of these fields will be hidden, give each of these fields the stealth class. (You can add multiple classes by adding a space between each class name in the CSS class setting.)
3. Create the drop-down fields, ensure that each has choices that correspond to the values in your database table. Give each dropdown the appropriate css class (race, gender, day), as well as the visible class.
4. On the Lookup Rules page, create your lookup rule and fill the single line fields (not the drop-downs) with the appropriate database values.

Then, on the CSS and JavaScript page, in the CSS section, add the following line:

.stealth {display: none;}

In the JavaScript section, add:

$(document).ready(function () {

    $('.day input').change(function () {
        $('.day.visible').find('option[value="' + $(this).val() + '"]').prop('selected', true)
    });

    $('.gender input').change(function () {
        $('.gender.visible').find('option[value="' + $(this).val() + '"]').prop('selected', true)
    });
    $('.race input').change(function () {
        $('.race.visible').find('option[value="' + $(this).val() + '"]').prop('selected', true)
    });
});

You could also do something cool like make the drop-down fields read-only if they get a value from the lookup.

Thanks Eric!

You're welcome!

Hi Eric,

Was this issue ever addressed? I'm using 10.1 Update 2 and am having the same issue. Is there a tick box I've not noticed? (not being sarcastic here)

-Ben

Ben, see this post - there is a plan to fix this behavior, until then you can use a workaround.

https://answers.laserfiche.com/questions/100142/DB-Lookup-makes-DropDown-values-disappear#107892

Append choices to lookup result for drop-down is now supported in Forms 10.2:

Nice one, Laserfiche team :)

Great, thank you and the team! Do we have a date when Forms 10.2 will be released? I don't see it in the downloads.

Did you see that Forms 10.2 is part of the main Avante and Rio distributions?

No, I didn't - thanks!

Having some issues with this new feature. 

In my form, I am recalling a value from the database. Only the data retrieved in shown in the drop down list. 

When I engage this feature, the value is no longer retrieved from the database. Instead, only the options configured in Forms are available. 

Thoughts? What am I doing wrong?

Hey Doug,

Did you ever get an answer to this?  We just updated a customer and are seeing a similar issue.