>Hi,
>
>I have two table in my SQL DB:
>Table1 (taCOD Char(3), taDate Datetime, taAmount numeric(10,2)....) and Table2 (tbCOD char(3), tbDESC varchar(30), ......). For these tables taCOD and tbCOD are PK.
>I have created 2 CA with Builder, using a connection string.
>I use the 2 CA in a form in order to manage Table1 (add, modify,...).
>The field taCOD must be referenziated by tbCOD.
>How can I link taCOD to tbCOD ?
>In DE I not be able to create a Relation from taCOD to tbCOD.
>
>Thank for your help and sorry for my poor english.
>
>Best Regards
In Init Event of the Form.
Put:
SELECT tbCod
INDEX ON tbCod TAG tbCod
SELECT taCod
SET RELATION TO taCod INTO tbCod
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.