>>I got most problem if mix all tables in one Form...
>>Because there relationship are cyclic!!
>>
>>Tables:
>>Customer(Cust_no, ... ) Carry Customer info
>>Orders(Order_no, ...Cust_no[FK]... ) Carry Each order info
>>Chooseitem(Order_no,item,....) OrdItems in meaning
>>Item(ItemKey, ...) Carry item info
>>Spprice(Cust_no,item, ...)
>>* Special Price lookup Table for each Customer
>>
>>But last table link two tables and form a cyclic relationship....
>>

>>                          Spprice>-----------+Item
>>              _____________\/   +              +
>>             /                   \________     |
>>            +                             /\  /|\
>>     Customer +-------< Orders +-------< Chooseitem
>>

>>
>>As VFP only make One work area, the link on finding will make a loop
>>and many unexpectly, or empty or multiple will come out on join
>>table....
>>
>>Currently I cut the Spprice Table into another Form to avoid this.
>>But the problem may happen sometime... ~>.<~
>>Any suggestion to me?!
>
>Don't create cyclic relationships, at least physically.

Of cos, I know... but current Dbase has them...
It take sometime 5-15mins to find records on printing.... +_+'