Hi

Any help would be appreciated as getting the following error :

An exception occured when trying to load entity. Property accessor 'DCLOPPSITEADDRESS' on object 'Sage.SalesLogix.Entities.DCLOPPPROJECTS' threw the following exception:'No row with the given identifier exists[Sage.SalesLogix.Entities.DCLOPPSITEADDRESS#O6UJ9A0003RB]'

i have an opportunity which has several 1:1 extension tables DCLOPPSITEADDRESS and DCLOPPPROJECTS being two of these.

i needed to then create projects on nav bar and put dclOppProject as a new mainpage and now i'm trying to create a tab with different text fields on to show the info in DCLOPPSITEADDRESS from the opportunity the tab can be seen if record exists or not. But created tab under dcloppprojects and created relationship on oppid from dcloppproject to dcloppsiteaddress and the tab only shows if record exists if record not exist the above error shows?!?!

Tried to create<DCLOPPSITEADDRESS> in the onload event of project detail screen (main page for projects) , but wont create it, and same error appears.

Please guys, tell me where this muppet is going wrong!

Extension enetities are problematic in SLX Web.  The ORM expects that the record will be there and will throw fits when it's not.  Your best bet is to go directly into the DB and make sure every Opportunity record has corresponding DCLOPPSITEADDRESS and DCLOPPPROJECTS records.  Note that when you create a new Opportunity, it will automticalyl create these 1:1 records for you.  The problem should only be with existing data.