The Paradox form system has an interesting peculiarity: any field which happens to be constrained by a foreign key within a native .DB Paradox data model automatically gets lookup values available for the user, but this is not available other database formats, whether they be natively supported within the BDE, or accessed using ODBC, so lookups have to be added in code.
Summary of a talk given by a Frank Fischer, MS .NET evangelist, Microsoft Germany, to the audience at the International Paradox Convention held in Frankfurt in 2004. .NET, of course, but also the ugly truth about Access and Visual Foxpro (VFP). Convention photo.
Earlier today, someone asked how to display the contents of Paradox formatted memo fields in a Delphi app.
I setup a basic solution, for which the source is given hereunder.
The idea is to define a calculated String field for the Query or Database used. Say be call it FMT in a table TBL, so its object name will be TBLFMT. In the OnGetText event for the field, add this code: