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

Click here to load this message in the networking platform