Initialize or get the data from Parent Table to Child Table.And this functionality is done based on Foreign key . Below is the Lookup functionality implemented to get the data from Parent Table to Child table using Init Method Step 1 : Created Parent Table with name Product Category (ProductCategoryID , Product_Category)and entered some data in it . Step 2 : Now Created child table with Columns (Product ID, Product Name , List Price ,Standard Cost,Quantity ) And these columns are related to Products.Now Create two more Columns one Category(String) and other Category Price (Real Datatype) . Note: In my case I had created the child table with name "InventoryProduct" Step 3 : Get All the values of ProductCategory column from Parent Table to child table column Category : 1. Create Relation in Child Table below is the .I had create the Relation name as "GetCategories" .And specified my parent table name in "Properties Tab -> Table" ...
Comments
Post a Comment