Information générale
Catégorie:
Codage, syntaxe et commandes
>>The user selects an invoice number from a list, the list is bound to the orderid in order_information. Why won't my grid believe the set relation. I see all records in the grid. If I suspend the code, brow the two tables and physically the order_information brwo window, then the grid will show only the records that meet the relationship.
>>
>>Ideas???
>>
>>
>>**** Init of my form
>>
>>SELECT order_information
>>SET ORDER TO orderid IN Order_Information
>>
>>SELECT order_detail
>>
>>SET ORDER TO TAG orderid IN order_detail
>>SET RELATION TO orderid INTO order_detail IN order_information
>>LOCATE
>>
>>***************
>
Sorry! Typo. That should be...
The relation appears to be upside down. Try
SELECT order_detail
SET ORDER TO orderid
SELECT order_information
SET ORDER TO orderid
SET RELATION TO orderid INTO order_detail
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement