In Accounts Module i have two fields 1)Account Name(single Line Field). 2)Parent Account (Lookup Field).

Now in Deals module i have these two same fields and both are lookup field. What i want is when i select the account name and then click on parent account lookup field, it should show the names related to parent account names only not all the accounts name.

same In this way i have so many lookup fields but i don't want all the data in each and every lookup field.

So can u please help me what is the best possible way to do this .