Diff sorces from diff tables in a built in grid combo !

[NiPat]

Hello all,

My grid has 5 columns, as below:

Form1.Grid1
===========
Col1 Col2 Col3 Col4 Col5
--------------------------------------------
CodeNo Date ActName DrAmt CrAmt


While Column1, Coulmn2, Column4 And Column5 are sourced from Table1 (Transaction), Column3 is a list of Customer-Name from table2 (Master).

I want Column2 (Date) , and Column3 (ActName) with the built-in combo. And when I click and select a name from this coulmn3 (ActName) combo, that particular grid row should dynamically reflect the corresponding data of that particular customer for that particular date.

Like-wise, if I select a diff date from the column2 (Date) combo, the grid row should reflect the corresponding change of data.

If possible, please elaborate further !


Thanks !

- Pat

 

[Mike Gagnon]

NiPat

Was there a particular question you wanted to ask?
Mike Gagnon

 

[danceman]

you need to start with the faq section, look at changing the grid recordsource programmitclly.

in you combox, put code to runn a select for the data based on the selection in combo. use the same name for the cursor to sendthe data to. this is the name that you will programmitcally assign to the grid. the big question is to deside where to put the code to run the select SQl and the grid refresh. it could be a button after the combo is used.??? Attitude is Everything

 

[rgbean]

Pat,
Grids are based on tables (or cursors), and if I understand what you are suggesting, you'd be using these rows to actually "query" the data in these tables, and you'd have to rebuild the grid with each change. Are you going to want to change the "looked up" data too?

Are you simply using the grid to compare multiple records' data? Do you really need to compare more than two or three? If not, I'd stick with individual comboboxes and textboxes (or labels) for displaying the data.

Rick