I am pretty sure I connected to the database correctly, as I did not get a connection error. when I tried to generate the model, I received the following error message.
--------------------------------------------
More than one item in the Entity 'PR' has the name 'X Charge Wks'. Item names must be unique among immediate siblings. (DuplicateItemName) Get Online Help
More than one Field in the Entity 'PR' has the name 'X Charge Wks'. Field names must be unique within an Entity. (DuplicateFieldName) Get Online Help
--------------------------------------------
'PR' is a table and it is related to the table 'XChargeWk'. Notice that 'XChargeWk' is not the same as 'X Charge Wks'. Any ideas?