I found the optional text fields in the I/C Item (3) Extension table but where is the data stored if I'm using it as a combo box?

Thank you

Mike

PS Is there a limit to the number of items that can be stored?

Hi Mike,

The elements are stored in the same file, regardless if you choose to select them in a Combo box or Finder field. I don't believe there is any practical limit.

Hi Mike,

I'm not sure if I'm understanding your question but...

When doing item maintenance, the data that you select from the "combo box" is stored in the item record in that table you mentioned above. So if you were doing a GridView that included the optional fields from that table, you should see the data that was chosen from the combo box when the item was created / edited being displayed in your view.

If you are asking where the combo box list of items are actually defined... Inventory Module | File (Menu) | Optional fields ...

I'll leave the limit question to Softrak but are you asking about the limit on the number of items that can be listed as choices for the Combo Box or the limit of Inventory items/products ?

Regards, Pete

The actual values are stored in a file called SDOPFV'D in the data folder

For GridView:

Module: "Adagio Common Files"
Table: "Optional Field Values"