Help !!! MSFlex Grid

[Dib]

Hi,

I have two tables first table containt two fields
Name and Recid

Name A = 1
B =2
C=3
D=4
E=5
F=6
G=7
H=8


The other table has two fields Recid and TestDate

lets say the data in this table are as follow

recid =1 date
recid =1 date
recid =3 date
recid =1 date
recid=6 date

How do I make the first table "Name" show up in Rows (8) and then put the
second table data according to the Recid in Columns

I also need to have an extra blank column lets say recid has 3 records so I
need to have four columns. the date field should line up according to
the recid example recid 1 would be A Row(1) and has 3 columns plus one blank
column and so

Please advice. this is the first time I am using MSFlex Grid control

Thanks
Dib

 

[Albert D. Kallal]

You don't mention at all how you are filling the grid. However, I don't see
why you don't just build a query,a and drop in the extra tables and do a
join.

As for using the flex grid, you can write code to fill it. However, I would
not use the grid control unless you really need to, as they can requite a
lot of code.

In place of a grid control, you can often use a listbox, or a continues
form. Take a look at the following screen shots:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

In the above examples, the grids are filled with sql, and you can thus use
the query builder to join those fields you need to lookup text values for.
The above apporach does save a lot of code.

 

[Dib]

In this event I will be displaying the data and also be able to add data as
well. I am trying to do testing on Chemicals and data they where tested on ,
this can grow up to about fourty coloumns. If I am doing using Continues
form how can I do that? I want for Row 1 to show all the columns with dates
and so on?

Thanks
Dib

 

[Adrian Jansen]

I just made a suggestion to someone doing a similar thing. See the thread

Re: Unbound grid control: Is there one? Other ideas?
in this same newsgroup.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control