Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Procedural Code Within a Grid
Message
From
27/08/2002 14:44:35
 
 
To
27/08/2002 12:58:44
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00694070
Message ID:
00694176
Views:
13
It's not necessary to use DE to set up a relation between two table. It can be done programmatically. It is not necessary to use relation for the case. It can be done with calculated field using seek command by setting up control source of the column to something like this:
=iif(seek(Art.TransCode, 'TransType', 'TransCode'), TransType.TransDesc, '')


>>Carmen,
>>
>>Create a new table named TransType.dbf;
>>
>>
>>TransCode N(the same width as the code in the AR table)
>>TransDesc C(80)
>>
>>
>>In this table put records like these;
>>
>>
>>TransCode TransDesc
>>1         Invoice
>>2         Adjustment
>>8         Cash Receipt
>>etc...
>>
>>
>>Now in the DE of the form set up the ARTable to be related into the TransType table on the Code and in teh Grid make the Conrtolsource for the column;
>>
>>
>>TransType.TransDesc
>>
>
>I agree with this, but using DE is not recommended if you wish to upsize to SQL Server or to make n-tier. (do not know whether in VFP8, DE will be better)
Yuri Rudenko
MCSD, MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform