Perefetch for Many to Many RelationShip

Posts   
 
    
Anthony
User
Posts: 155
Joined: 04-Oct-2006
# Posted on: 20-Sep-2008 06:33:45   

dotnet,llblgen v2.6,adapter,MS Access

Table 1 : Skill SkillId int (Primary Key) Skill String TypeId

Table 2 : Type TypeId int Type string

How do create a join between these tables. In MS Access it says the join is indeterminet

Can i create a virtual join in the designer for this?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 24-Sep-2008 07:14:49   

You can add Add custom relaitons, however Table2 must have some PK.

What is the PK for Table2?

(Edit) If Table2 doesn't have any PK, you'll be able to select which fields are part of the primary key by selecting a checkbox ('Is part of primary key') on the field properties tab. The checkbox isn't enabled either if the currently selected field is part of a relation or the field is nullable.

David Elizondo | LLBLGen Support Team