Sage 100

UDF in UDT - Data Source Tab not available It is scary when I try and actually do work. I am trying to add a UDF with a one to many relationship with an inventory item. I created a UDT to store the values of the UDF that will be associated with the items. Then I created a second UDT to store the relationship between the items and the UDF. The first field that holds the valid values from the first UDT was added and I was able to validate from the Validate tab to the UDF. THen I try to add the second field to hold the inventory item and no matter what I do I can't get the tbe 3.Data Sources to be available. There is no help worth a damn. I am probably missing something very simple, but... Please HELP.

I can see the Data Sources tab on a system defined table like CI_Item or SO_Sales Order Header. Is this a limit on UDT's in Standard or Advanced (Providex)? You can definitely do this in a regular database!

Is it a one (item) to many (UDT)? Or a one (UDT) to many (items)? Or is it many to many?

An item may have many UDFs from the UDT. We just want the UDFs controlled rather than free form text. We don't want to specify 6 or n values and then link to the UDT (which can definitely be done). So we setup the extra UDT to store Item - UDT relationship and then let it have as many values as necessary.