Below is the code from the init of my form.

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

***************