populating a DBGrid based on...

Posted by Anand Subramanian on March 07, 2004 at 11:58:24:

Hi,
plz tell me how to populate a DBGrid based on a value in a DBTextbox.

I have a DBtextbox in which a column(say Ordernum) of a particular table gets populated. Each succeding column can be navigated through a navigator control button.For each value appearing in this DBTextbox, I should populate a DBGrid with all fields from another table which have records with orderno = (the orderno in the above DBtextbox)