Jeff,
>OK, I'll agree that there's a better solution for the addresses problem.
>
>How about in general. If I'm working on employees and I need to identify the supervisor (another employee). Or I'm in Inventory and I need to refer to a set of alternate inventory items (in case I'm out of stock). How do I handle two distinct references to the same table?
With just the information you have provided here, it sounds like the best approach is still to have multiple DataTables associated with a single business object. Make sure you check out the MM .NET Dev Guide topic "Working with Multiple DataTables in a DataSet".
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com