I'd suggest looking into derived tables. I haven't done them with Oracle but a quick Google indicated they're available in Oracle. Basic idea w/b one derived table for parts and one for services then outer link each to the other master tables as needed. Christie Mason