Raju Fodse

Raju Fodse

  • 1.4k
  • 244
  • 29.3k

Pass Master Table value to child Table

May 7 2019 5:25 AM
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.   
 

Answers (1)