BorlandTalk.com

Minor Bolanos · Guest

Hi
I have a Paradox master:Customer Table/detail: Shipping Table relationship
with the master having only one Primary index field: -say Customer ID.
On the Detail I have 3 Primary Indexes: CustomerID, ShipID, and CodeID.
I created a secondary Index on the Master: Customer table (CustomerID;Ship
ID)so I can Join one customer with different CodeIDs that have the same
ShipID. However, after selecting the Master Source: Customer Table and the
master fields(CustomerID and Ship ID) on the detail table, when running the
program, it reports that it cannot access the SHIP ID index.
Example of what I want to see.

Master Customer
CustomerID: 123
ShipID: 001

Detail:
CustomerID: 123
ShipID:001
CodeID: 55

If I only join with the CustomerID I don't get the error message but the
Detail Table has all the Ship IDs for that customer on the Detail Table. I
would only like to see a collection of the same Ship ID's with different
CodeID's per customer on the detail side.
Thanks.
+Mines

Bill Todd (TeamB) · Guest

Did you set the IndexName property of the detail TTable to the name of
the secondary index?

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Minor Bolanos · Guest

I created the secondary index but was linking the tables by means of master
table fields. After switching to the index name, the link works like I had
intended.
Thanks for your help
+Minor

"Bill Todd (TeamB)" <no (AT) no (DOT) com> wrote