table joins to on grid

[fishman13]

I have two table, one for charges and one for payments. The tables are related by a transaction number. I would like to join these two tables and display certain columns in a standard grid. On such field would be the date, in the charge table is it called cdate and in the payment table it is called pdate. Is there any way to have these two dates, and other similar fields displayed in the same column on the grid

ex

date Trans type amount
6/1/2003 C 100.00
6/16/2003 p 50.00

 

[ramani]

Hi,

You can do it in number of ways.

1. Having a common cursor, which picks up the date in a common field by SELECT statements.

2. Have two textboxes in the dates column.. Text1 and Text2.
Make the Text1s control as cdate and the Text2s control as pDate.

Now make use of dynamic current control to diplay Text1 or Text2 based on Transtype = C or P.

You have to put this code in the init of the Grid.








ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com