>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.