Select different fields - have it copied into a list box and populate

[Techniproshop]

Hi all. I always wanted to make a Query tool wich people can select only the fields of one or mutiple tables. Right now, when a user wants a specific query/report, I have to create it for him but it will be better if the user can create his own query.

From a combo box, they will select the fields they want. All selected field has to be copied in a Text box. Then the user press a button to view the result of their query.
Any directive you can give me so I can build this thing?

Thanks!

 

[PHV]

This thing already exists: it's the query wizard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Techniproshop]

Well yes but I don't want them to access all the tables so If I create my own Query builder, I can give access to certains fields/tables only.

 

[TheAceMan1]

How are ya Techniproshop . . .

[blue] . . . but I don't want them to access all the tables so If I create my own Query builder, I can give access to certains fields/tables only.[/blue]

As the best starting point I can present, have a look at [blue]multiselect listboxes![/blue] Normally the selections are concatenated into an [blue]SQL[/blue] statement.

Since your talking more than one table, your hardest venture here will be taking into account your [blue]Table Relationships[/blue] (of which we know not).

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .