You resolve the many-to-many relationship by putting a third entity between the two, which will state how any of the item are in a particular warehouse.

Fine here is my idea, Tell me if I need to imporve or change..

There are 2 table im going to use for that
1. warehouse_master(warehouse_id, warehouse_name)
2. current_stock(item_code, item_descripton, quantity, warehouse_id).

What my worry is if my product master has more item like 1000 items then i need to repeat all item for each warehouse in order to maintain warehouse wise.

Does this will affect the perfomence when I fetch the details on forms?

Is there anyother way to achive this?

Now please share your idea..

Thanks.