Table with no primary key

• Gary Ogren

  Newbie

  Points: 8

  More actions

  November 16, 2006 at 1:03 pm

  #368067

  I want to create a report model with five tables, one of which has no primary key (bad design, I know). Using the report model wizard four of the tables end up in the model but the one with no primary key does not. Is there a way to get this table in the model? It is a table on an Oracle server that I have linked to via sql server.

• Martin N

  Ten Centuries

  Points: 1216

  More actions

  November 19, 2006 at 5:09 pm

  #672848

  yep. you just righ click on the field(s) you want to make primary key and select the 'make logical primary key' option. Then it works.

  ---

  Kindest Regards,

  Martin