General information
Category:
Coding, syntax & commands
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only