Form - Many-to-many relationship

Applications Forms
#1

Hi!

I have a form with related checkbox,

the checkbox contains records from another table (mysql) and I need to hide one of them.

image

is there any way to do this?

#2

You can hide it in jQuery or modify the SQL Select statement to exclude it

#3

will you have an example that you can provide?

#4

Wich one, jQuery or SQL

#5

can you share both? I can’t find where to modify the sql

#6

in onScriptInit, get the checkbox ID with inspect, this example will hide the second box

?>
<script>
$(document).ready(function() {
$(’#id-opt-groups-1’).hide();
});
</script>
<?php

or SQL

This example will remove group with id 3

image
image1090×352 14.2 KB

2 Likes
#7

thank you very much jlboutin60! both worked for me :smiley: