Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About CA for MSSQL Table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
00995260
Message ID:
00995287
Views:
14
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform