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
Nino