its a problem of OR mapping...the middleware being object oriented, it becomes difficult to map it into a relational model....hence it has been simplified to tables corresponding to the attributes of objects in the middleware. hence there are no relations between ny of the entities...ne suggestions?