How to get data from a weird database

[hermes15184]

Hi there,

I'm a noob in vb6, and I need some help to get values from a weirdly structured database.

Information is stored in such a way below:

ID Order Param_ID Description Min Max
1 10 1000-Proc Processing null null
2 10 1000-In Visual Check null null
3 10 2000-Strt - 0 10
4 20 1000-Proc Processing 1 2

So basically what I need is to get information for Order 10 and depending on the param id the output will either be column description, min or max.

Really appreciate the help. Thank you so much.

[techgnome]

what does the output need to (or supposed to) look like?

Depending on what you need it to look like, there are at least 2, maybe three ways to do this.

-tg

[hermes15184]

so basically i was thinking of having a drop down list of the orders... so 10,20. and when the user chooses one of the orders say 10, all relevant information regarding that order will appear.

Drop Down
10
20

Order Description1 Description2 Description3 Min Max
10 Processing In Visual Check - 0 25

Thnx again!