When adding tables to a report, is it possible to avoid getting two or more lists of the same tables in Database Expert?  If this happens, how does one get back to only one list? I have reached a point in some reports where two or more logons to the database are necessary in order to get the reports to run.  As a corollary to this, one of my reports is sending multiple invalid passwords to the mainframe where the DB2 tables reside and this causes my password to expire.  Our RACFID guru suspects that this may have something to do with the multiple logins.

You can use "add command" option and use your SQL there to select the field that you are going to use for the report instead of drag and drop of tables. If you have multiple instances of tables in the database Expert, you can remove one by selecting the unwanted table and clicking on '<'