i am trying to create a consumable asset in the alm_consumable asset table but it is not populating correctly . as on the catalog item form , i have set a drop down list for the stock room and the catalog as reference .
@Ankur Bawiskar i found my answer which i was going in the wrong direction
i used this table with reference and it worked : cmdb_consumable_product_model
@Ankur Bawiskar there is no data issue . here is the picture of the consumable table . each item can appear in different stock room . what i am trying to archive is that once the asset manager purchases the item , it should create the consumable entry based on the form which will specify the stock room .
@Ankur Bawiskar this is how the form looks like : i do not filter based on the stock room . the requirement is to do bulk order based on the form . so a general catalog is being used . when i set the stockroom as the reference list it is getting populated to the new consumable field but the catalog list selection is not .
when i change the lookup box for the catalog item to reference i am able to select the display_name but from the catalog form too many duplicates .
@Ankur Bawiskar i found my answer which i was going in the wrong direction
i used this table with reference and it worked : cmdb_consumable_product_model
