Need Help with Stock Transfer Form – Warehouse Issue

[shobhanauto]

Hi everyone, how are you all?

I’ve created a form for stock transfer between warehouses, but it’s not working. Can anyone help me?

Details:

• Total Warehouses: 4
  
  • W-ADMIN
  • W-MAIN
  • W-RETAILS
  • W-LOCALS

The form is supposed to transfer stock from one warehouse to another, but it’s not functioning. Any guidance would be appreciated!

 

[Gasman]

I am on my phone now, but if your structure is correct, all you should need to do is change the FK for the stock PK in the WarehouseStock junction table.

 

[tvanstiphout]

<clip>

There are other issues but start with thinking about these 3.

A few more that immediately caught my eye:
1. Dnt abbrev obj nms - Don't abbreviate object names. You are creating this not just for yourself, but also for your successor after you win the lottery. Even your Descriptions in table design are often abbreviated. Also, a description of "STINNR1" for a field named "STINNR1" does not add any value. Also, you have no required fields other than PK. A blank record never makes much sense. Several blank records never make any sense.
2. ItemName is not an appropriate table name.
3. As Pat already said, this table does WAY too much work. It may have started in Excel perhaps? Anyway, this is not how you create a relational database. Stop development now, and read up on relational database design and the rules of normalization. Study some good templates, such as the Northwind Starter and Developer databases.
It would be interesting to contemplate how we would add multiple warehouses to Northwind. I'll kick that around with my team member Kim. Also note there is a YouTube video about how we implemented inventory in NW2-Dev.