Lookup tables & SDP concatenated key
Summary:
We have a very large number of lookup tables in our app, and rather than have so many data maintenance programs, we'd like one lookup table and maintenance program with an extra field (call it 'Type') to distinguish between the different lookups (as in ERPs like Oracle JDE). So we'd need the SDP to have a concatenated key of Type & Key … the Key by itself wouldn't be unique, it would only become unique with the concatenation of the Type with it. We couldn't get that working with the SDP though, even
Tagged:
0