Report Model - Missing entity

• cbreshma

  Old Hand

  Points: 332

  More actions

  February 1, 2008 at 12:21 am

  #378238

  Hi ,

  I created 3 tables in SQL server magmt studio as

  student - sno (pk), sname

  subjects - subno(pk), subname

  marks - sno(fk), subno(fk), marks

  While creating the report model:

  1.Created the data source - no problem

  2. created the data source view - no problem added all 3 tables here.

  3. created the report model - only subject and student show up here. Where is the marks table?

  Please help

  Regards,

  Reshma