You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!