establishing relations??

[asd123456]

Hi friends,
Please inform me the way to establish relation 1:M between 2 tables using MySQL Administrator? Like, I need 2 tables:

BANK
id_bank name address
1 A B
2 C D

ACCOUNTS
id_bank account_N
1 1000001
1 1000002
1 1000003
2 2000001

Many accounts can be related to each bank. I described id_bank in ACCOUNTS table as foreign key, but I could enter into ACCOUNTS only one row with each id_bank.
Please, help me!
Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sierra]

Maybe, you could have set wrong PRIMARY or UNIQUE KEY on id_bank in your ACCOUNTS table. The PRIMARY KEY on ACCOUNTS should instead be (id_bank, account_N) if you want the possibility to have the same account_N for different banks or only (account_N) if you want it to be unique across all banks. In this second case there should just be a simple INDEX on id_bank in ACCOUNTS. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --