david wrote:
You can change the type of relationship (many-to-one to one-to-one) and the direction, eg, bi-directional to uni-direction or in your case no relationship. To do this hold either the CNTL key or the SHIFT key down when clicking on the end of the relationsip line your interested in. This is in the documentation.
case no relationship? CTRL key + click ?
>>>>>>>>>> can't change the cardinality of the one-side of a relationship that correspondes to primary key.
example tables:
create table member (id, name, pass, answer, question, primary key(id));
create table memberinfo(id, email, primary key (id), foreign key(id) references member(id));
i can remove the arrowhead or change many to one , but i can't remove the relation line and the one-to-one relation
>>>>>>>>> and i think if i must use the gui , it's unuseful. because i have several hundred tables.