You are viewing limited content. For full access, please sign in.

Question

Question

Populate a drop-down from a data source

Forms
Updated October 16, 2014
asked on October 16, 2014

I know that I can populate a drop-down list based on a choice made in another field.  But how can I populate the drop-down without an second field?  

In other words I have a table with a list so vendors (that will be changing as new vendors are added) and I want this list to be the values available in the drop-down for the Vendor field.  Would I need a stored procedure or can I do it with look-up rules?

Thanks,
Sandy

0 0

Answer

SELECTED ANSWER
replied on October 16, 2014

Next to the "When" statement, click the 'x'. Then just configure the "Fill" statement.

3 0

Replies

replied on October 16, 2014

I'm not sure I understand. If it is just a database table with the list of vendors, you can just do a simple database lookup and have it "fill" the dropdown field for vendors.

1 0
replied on October 16, 2014

I think you just need to click the "X" to the right of the "When ___ matches data source column" line in that screenshot you posted. Then set up your fill condition to pull the column you want.

1 0
replied on October 16, 2014

I guess I'm missing something - so what would the look-up rule be since I'm not matching anything I just want to get the list. Just fill the drop-down with the VendorName values.

 

0 0
SELECTED ANSWER
replied on October 16, 2014

Next to the "When" statement, click the 'x'. Then just configure the "Fill" statement.

3 0
replied on October 16, 2014

Ohhh.... I'll try that.  Thanks

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...