Use concatenation for your UDT key field to string multiple field values together (using a unique separator like "^" or "~").

Either that or consult with a Master Developer to get a custom enhancement.

Kevin,

I've seen that other developers use the concatenation technique and, assuming a good concatenation approach, that would help with the primary key part of my question.  But what about multiple indexes?  This seems like a very basic thing that many integrators would require.

I don't think I've seen the title 'Master Developer' appear in any of my readings.  Where would I find the resources that gives one the education to get such a title?

Sage will have to answer the question about how to become a Master Developer.

(Since I'm not a MD myself, I can't answer the index question either... I think you could add that in SQL if using the Premium version, but for a Providex back end, I don't know what's possible).

Kevin,

I appreciate your responses.  The differences in the tiers regarding data storage is certainly unusual!

Kevin,

I appreciate your responses.  The differences in the tiers regarding data storage is certainly unusual!

Sage 100 was developed originally with a Providex back end.  Years later a SQL back end option was added (although the core program is still written in Providex), which is the "Premium" version. 

"Standard" is the base version (originally MAS90), with no client-server architecture (where workstations access the data files directly).  "Advanced" (originally MAS200) is almost the same as Standard, but with a service for client-server performance benefits (necessary for higher user counts).

MAS200 was originally MAS90 C/S   that goes way back

BigLouie knows the history far better than I do.  (I've only been working with Sage 100 for about 8 years now).