SQL Connections defined on this tab are available as connections when configuring Dropdowns and Lookups in both Header and Detail fields.
To create a new SQL Connection:
Name the connection via Connection Name field
Enter the Server and Database
Choose Authentication type
If SQL Server Authentication you must enter a Username and Password.
Click the blue “Save” button
To delete a SQL Connection:
Select the SWL Connection from the dropdown that’s filled with “Choose A Connection”
Click the red “Delete”
To edit a SQL Connection:
Select the SQL Connection from the dropdown “Choose A Connection”
Edit values, and Click the blue “Save” button on the bottom
Pressing the green “Create New” Button will clear our all the fields so that a SQL Connection can be entered, but the blue “Save button needs to be pressed in order to actually save the SQL Connection