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