Wish submitted by:
tim.barr@21appr.com On: 11/20/03
Just like the user must identify (or create) a SQL field that contains the unique 'Record Number', The user would have to identify (or create) a SQL text field (up to 7 characters) that would contain a qualifier ID to match the definitions in the traditional MAP. Where the high-level interface reads or writes data (IUA, RREPORT, Lookups, etc) it would need to know (from PFQUAL or the usual qualifier syntax) to add the appropriate 'Where FPQUAL = 'XYZ' ' to the Select command. All qualified data would be stored in a common physical SQL table. SQL views can be used to separate customers.
