[snip] Would you want to maintain 4 separate multivalued attributes in CUSTOMER to track all ORDERS, INVOICES, CONTRACTS, SALESMAN, etc. ids? [snip]
Actually, I would. And I do. (Usually) That way I can use simple translates from CUSTOMERS to ORDERS, INVOICES, CONTRACTS, SALESMAN, etc for reporting (and selecting) those related records from the CUSTOMERS file. I agree that retrofitting an existing system to maintain those mv-lists is a pain. In those cases I usually end up just creating an index on the "other" file that points back to the primary file, as you suggested. But I find that I miss the quick reporting and "smarter" selecting (which seemed to be the intent of the OP) that comes with the mv-list-of-ids approach. Thanks for your XSELECT suggestion. Just an old pickie, Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
