Need a solution for two grid in one screen in which second grid display data once first grid row get click

[Zifan]

Hi..Good Morning to everybody...

If any body have solution using TList for the following
requirement,I'll be more thankfull ...


1st requirement *****

I need a solution for a screen with two grids and It should work as
follows

First the both grids should display with form load and 1st screen
should display with data from the database and once the user click a
line from first Grid the second grid fill up with data which is
loading from the database And the second grid containing 6 columns and
out of that 3 columns data automatically displays(User cant modify)
and the rest 3 columns user inputing data and those columns should be
validated against user input at entry level.(eg. 4th colum should be a
Mask edit,and 5th column is decimal input only and the last column
integer only).

The second column of the second grid is concatenation of five database
fields.

So It should support me to bind my sql query to load the second
grid(first 3 columns).

Also need a check box field to embed in the grid

(This is the most important screen...and I think you may have solution
with TList)


2nd Requirement

A screen with a grid should load the data from Database at form load
and If the user types something it should search from Grid and
highlight the most suitable record lines from the grid(eg. User may
type 1 and then all records starting with 1 only should display or
prompt,,when he type 1and 2 it should prompt recs starting with
12 ,,,like 123...123-Fl-....123-FL-127... so on...

also what ever he type should display on a lable box or text box which
located outside the grid.

once he click on a record it should display the entry screen for that
record with data.The entry screen contains 3 grids


And if user type anything(modify or insert new) on those grids and
when he close the screen and when he open again the same those
modified and newly entered data should be in the screen as it was when
he leaves the screen last time.

Also when user entering new records in the first(most top) grid, the
new and old data should be presented for the combo box located in the
second grid.

And also if he enter insert button (which located at the bottom for
save) it shoould clear all the data and display empty screen with
empty grids For a New Entry


Note: My Back end is SQL server 2005 and my front end is VB6 .

If anybody have solution for me with Tlist please help me with some
samples.

Currently I just install the 30 day trial of TList and my company
ready to by this component if it exactly works with our requirement .
(Currently I did more coding to a vb6 fleex grid to do thge above
tasks and still it's not much user friendly..thats why my company
needs me to use third party grid)



Muhammeth Zifan
ERP Consultant
Al Ebdaa Establishment For Development
Jeddah saudi Arabia