I was able to get this working as a test.

If you need multiple checkboxes to be able to be selected, I would recommend filling the hidden field with all the values, separated by some unique value. Then you can use Javascript to iterate through the values using a split function on the string and you will be able to select all your options. 

$(function() {
  $(document).ready(function () {
    var value = $('.FilledField input').val();
    switch (value){
      case "1": 
          document.getElementById('Field2-0').checked = true;
          break;
      case "2":
          document.getElementById('Field2-1').checked = true;
          break;
      case "3": 
          document.getElementById('Field2-2').checked = true;
          break;
      default:
        alert(value);
    }
  });
});

If you change the "true" to "false" it will unselect that checkbox for you. 

I have no experience with Java so hope you don't mind the probably simple question.    What would multiple statements look like? 

Thank you in advance.

I actually realized I over complicated things, which happens a lot when you deal with stuff like this. You wouldn't need to format the text, just go ahead and loop through all the auto-suggestions, similar to how it is done here:

$(function() {
  $(document).ready(function () {
     var tester = $('.FilledField datalist select option').length;
     if (tester > 0) {
        $('.FilledField datalist option').each(function(){
            var option = $(this).val() - 1;
            document.getElementById('Field2-'+option).checked = true;
        });
     }
  });
});

$(function() {
  $(document).ready(function () {
     var tester = $('.FilledField datalist select option').length;
     if (tester > 0) {
        $('.FilledField datalist option').each(function(){
            var option = $(this).val() - 1;
            document.getElementById('Field2-'+option).checked = true;
        });
     }
  });
});

I subtracted '1' from the values in the suggestion to be able to adjust for how Javascript references the field. You can remove it if you start at zero for the suggestions. 

I put in the suggestions "1" and "3" and got this output:

You will need to adjust the number in  "Field2-" part to be whatever field it is you are using.  Also, you will need this to be a function since it will need to trigger after the lookup is performed. Can you post some sort of screenshot or inform me the field number/CSS Class of the field that would cause the lookup to occur? 

Also, if you tell me what field number your checkbox is, I can help iwth that as well. You will need to apply a CSS class like I did to the hidden field for it to find and go through all the values

I think I may have misunderstood the request here.

If I am correct, you want to take a checkbox field and use it's selected options in a SQL Query/lookup so that in the next form step that certain information is populated from that information to other fields? 

To do this, we need to understand how each option effects the query. Say, if you want it to be if the checkbox is enabled for option 1, then 1 lookup occurs, but for each subsequent checkbox that is selected, a second lookup is performed that updates other fields. 

The other option is each option selected effects the overall lookup and you set up only one lookup to occur.

Either way, we will need the use of a hidden field (or 5 if you choose the first option I mentioned) and use javascript to take the selected items and fill the field(s) with information depending on if they are selected. Then, in the second form, we would use javascript to trigger the lookup when the form is loaded, giving you the result you wanted.

Let me know which functionality you are looking for so that I can give you a hand in getting started.

Kenneth,  I am looking to take a value from a stored procedure into a single text box  and then use the content of that text box (Value 1-5 but a single value) to select a check box in the form.  I have tried to get your first example to work as seen in the attached photo but am failing miserably.  Did I mention I have no understanding of Java and the data guy in me says it's just another variable why is this functionality not built into the system...

So if you can point out where I have messed up your code it would be great.

You changed things to 'q' Change all those to 'Field'

Also, in line 3, you need to keep it how I recommended in the field place:

var value = $('.FilledField input').val();

Otherwise it is not getting the value from the field. 

Last thing, you will need a value in that field, so set a default value for it as a test, or add a field that would represent the field that causes the lookup, at which point, you will want to assign that field a CSS Class name like "TriggerField" and then you would need to change the code to the below code snippet:

$(function() {
  $(document).ready( function() {
     function Checked() {
      var value = $('.FilledField input').val();

      document.getElementById('Field2-0').checked = false;
      document.getElementById('Field2-1').checked = false;
      document.getElementById('Field2-2').checked = false;
      document.getElementById('Field2-3').checked = false;
      document.getElementById('Field2-4').checked = false;

      value -= 1;
      document.getElementById('Field2-'+value).checked = true;
    }

    $('.TriggerField').on('change','input',Checked);
  });
});