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

Question

Using a single value to populate a multi line with multiple values from an SQL.

Forms

Updated October 9, 2015

asked on September 30, 2015

We are looking to have an employee number put into a single line.

Based on the User, there may be multiple accounts or none, depending on each person. So we have set up an SQL table that has all listed accounts based on the User number. What we want to do is have every possible account connected with a persons user number listed in a multi line like this:

How would I do this?

0 0

Answer

SELECTED ANSWER

replied on October 9, 2015

Hello James,

You can accomplish this by using custom Javascript. Here is a Javascript example that I found on Answers which is similar to your use case. It should enable you to append multiple lookup values into a single line or multi-line field.

Alternatively you can create a SQL Store Procedure and use Forms Lookup Rules to populate the returned values in a field. For information on SQL Stored Procedure, you can check out this technical documentation on Microsoft.

Let us know if any of these options work for you. Thanks!

1 0

Sign in to reply to this post.

Asked September 30, 2015
Updated October 9, 2015
265 views

Question

Question

Using a single value to populate a multi line with multiple values from an SQL.

Answer

Replies

Sign in to reply to this post.