Your tables needs to have a primary key index. It's the index that you drag from one table to another to create a permanent relationship.

HTH

>I am still not understanding. Does the Database Designer supposed to have relationship (1-to-many) and does it supposed to be "permanent" unless I deleted the relationship? I can open the Database Designer but can not drag a field to other table(s) to create an relationship. I could do it from Data Session, but I want more than this basic (like the different kinds of deleting and updating fields...)