Could it be that your fields are of different lenght? Did you verify relation in a command window?
>Herman, I put "ADDITIVE" in, but it still won't show the Customer Name in the grid column. The controlsource says "Customer.Customer", which is the actual customer name, yet it won't display. I have the carrier name displaying perfectly each time, but not the customer name. I used a LOCAL VIEW and that worked fine in displaying the customer name. But, why it won't with a regular FoxPro table is strange to say the least. In one case, the SET RELATION works fine, yet in the other, it doesn't work.
>
>>Hi Cecil,
>
>>If that code is the exact code, then you need to use ADDITIVE clause in the second relation to preserves existing relation.
>
>>SET RELATION TO Cust INTO Customer <-- Does NOT work.
>>SET RELATION TO Carrier_ID INTO Carriers ADDITIVE <-- This one works.
If it's not broken, fix it until it is.
My Blog