>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
>
>***************
Try this instead:
SELECT Order_Information
SET ORDER TO Orderid
GO RECNO() && Force record pointer to move to activate the order
SELECT Order_Detail
SET ORDER TO orderid
SET RELATION TO orderid INTO Order_Information && Additive if others active
LOCATE