Select Window

To avoid typing mistakes, the referential integrity select helps users to select data that has been entered once in the system, and is referred again in any datagrid for link. In the example above, while entering a Items to ItemGroup , the Items can be selected by clicking Add>,Add All>> button. Select Item or Items and click on Add> button.The selected items will be added to the right panel and click on Save.Same wa user can add the entire list of items by clicking Add All>> button. Also Items can be removed by clicking Remove, ClearAll buttons and click on Save button.Also user can be click on Copy from Clipboard option to copy the data from external files like Excel, notepad etc and add to the select window

Select Combo

To avoid typing mistakes, the referential integrity combo box helps users to select data that has been entered once in the system, and is referred again in any datagrid. In the example above, while entering a sales order,

the Item can be selected by clicking the button, instead of having to type it once again as it has been defined in the Item Master screen. Once the combo box is up, search can be made either on the item or item description by just typing the letter and press enter in keyboard or click on select button in the bottom

Here the item is filtered by letters starting with "A"

A second level of filtering also “filters” only those entities that have a relation specified in the database. In the above example, a relation is defined in “ApprovedCustomerItems” screen that specifies which Item can be ordered by which Customer. So once the item has been selected in the sales order, the “Customer Name” column automatically filters itself such that, only customers who can order the item are made available for selection.