Loading

Pass Master Table value to child Table

Raju Fodse

Hi!

I have two tables

1) Category (CatID (PK), CategoryName)

2) Product (ProductID (PK), CatID(FK), ProductName).

I already create CRUD view for Category now I want to add child table data (e.g. Product). I want to open detail view of category and in this view I want 'Add Product for this Category' link. On clicking this link 'Product' table add view should open. And catID value of category detail view should automatically takes in product tables CatID field. Is it possible ? Please help.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Anoop Kumar Sharma7y ago
Accepted answer
Hi Raju,

Yes, that's possible. On clicking on Add Product for this Category, pass CatID as a QuerytString parameter and receive & bind it in the Add new Product View so that on posting or saving the product, you can get the CategoryID associated with it.

Hope this will help you.