Drop Down Components that Interact with SQL Tables

I am trying to create, what we call at work, maintenance screens. These are screens that take input (ex. drop down) from our customers and the data is used to insert and update data records in SQL tables. Data can also be displayed and a record in the table can also be deleted. ,

So, my first question is has anyone done something like this? It’s strictly just interacting with SQL Database tables.

One example would be when a screen is called up, a select statement to tables retrieves data that are used to fill the drop down boxes.

I hope I’m making sense!

Thanks in advance,

This is totally possible and easy with SQL Query Bindings in Vision - Ignition User Manual 8.0 - Ignition Documentation (inductiveautomation.com)

Thanks! I’ll check that out.