I want to link two tables, the main table has a field called custnum, which can have many of the same values, so I have to index it regular. But the customer table has the same custnum field, but it cant have repeat values so I have to candidate for primary for the index. I want the main table to be the parent table, but when I relate the two, the customer table becomes the parent. Is there any way I can stop this from happening but still link the two tables the same?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
parent tables in 9.0
- Thread starter Samalia
- Start date
craigsboyd
IS-IT--Management
Something like the following...
SweetPotato Software Website
My Blog
Code:
USE "f:\main.dbf" IN 0 SHARED
USE "f:\customer.dbf" IN 0 SHARED
SET ORDER TO TAG custnum OF "f:\customer.cdx" IN customer
SET RELATION TO main.custnum INTO customer ADDITIVESweetPotato Software Website
My Blog
- Status
Similar threads
- Locked
- Question
