Visual Linking: Can link by 2 fields? 
Author Message
 Visual Linking: Can link by 2 fields?

Hi,I am using crw4.6 comes with vb5.0.
I've noticed that the visual linking for 2 tables can only based on 1
field.
 But I have tableA and tableB, the unique key of these 2 tables is :
field1+field2. In vb5 program, I can use sql     " where
tableA.field1=tableB.field1 AND tableA.field2=tableB.field2 " or
        " tableA INNER JOIN tableB ON
tableA.field1+tableA.field2=tableB.field1+tableB.field2"
But how to do the linking in crw4.6?
Please help me if you have any idea. Thanks a lot.


Sun, 04 Mar 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Visual Linking: Can link by 2 fields?

2. linking all fields in linked table?

3. To link procedure and table in visual linking...

4. HELP: linking txt field with a memo field

5. Linking 2 fields to 1 field

6. Linking 2 fields to the same field

7. Changing the linked table path without the linked table manager

8. Delete link and recreate link automatically

9. Excel Linking and Excel/Access Linking

10. Linked tables - changing the link

11. Changing Linked Table link?

12. Adding a contact link in the Links Collection

 

 
Powered by phpBB® Forum Software