Item Group

The Item Group table specifies relationships between inventory items. The relationship of parent/child allows the user to request one item (the parent) that consists of two or more stock items (the children). For each Parent Item, a list of Child Item(s) with its Description and Quantity is displayed.  Parent and Child Items must be valid on the Commodity table and a parent record cannot be a child of another parent or of itself.

The Item Group table allows you to search by the Parent Stock Item. You can also search by the Child Stock Item by clicking on the Search by Child link on the Item Group table. This takes you to the Item Group by Child (ITMGC) table, which can also be accessed from Page Search.  By entering search criteria for the Child Stock Item, it enables you to find all associated parent items. You can then select the desired record from the grid, click on the Item Group link, and the associated Parent item record is displayed.