How to create an enduser query form

[ettropics]

I would like the endusers to be able to click a button and create his/her own queries using a windows form.

 

The endusers are used to being able to create queries on the fly in an Access database that we are moving away from. And the new database is in SQL and VB.net.

 

Any ideas on how to accomplish this query form?

 

TIA

[Robby]

Most of this can be done with great ease if they will create the query based on one table, but if you want them to build on multiple tables using Joins, it won't be so simple.

[ettropics]

This will need to be done where they can query multiple tables. Is this something that can be done through Crystal Reports? I am unfamiliar with this so please bear with me.

 

Thanks for your input

[Robby]

You said ... the endusers to be able to click a button and create his/her own queries using a windows form. "

 

Will you provide Field names (in a ComboBox) and a textbox where they can enter a value, or something like that?

 

I may have miss-understood, can you explain.

[ettropics]

enduser query form

 

If it is possible, I would like for them to be able to click a button on the main form that will open up a query form ...

 

basically after that I would like to make it as simple as possible. Something along the lines of creating a query in Access, where they can choose the tables and create the query from there involving joins, etc.

 

combo boxes for selecting tables

combo boxes for selecting fields

ability to join tables, etc.

 

I am starting at ground zero, so any suggestions, etc. are welcome.

 

Thank you...

[Cassio]

I would do it manipulating SQL strings. Since the user will have to give all the information (like FK) it woudnt be hard to do.