Linking tables with EER

[Pete Watters]

Table material
material_id_sys Primary key generated auto increment


Table Prefered_Manufacture
prefered_mfg_id_sys is the primary key which is auto generated and not used
Material_id_fk links to the material table material_id_sys
prefered_mfg_fk is a foreign key linked to the manufactures table primary key

In EER Diagram

I hand created a column for the foreign key but when I linked the Material table and the Prefered manufacture table it create a new column/field for the
table. Should I delete the one I created and clean up the name of the key that was generated

Now I want to link the MANUFACTURE table to the PREFERED_MANUFACTURE table
the manufacture table has one unique id for each manufacture mfg_id_sys
and the PREFERED_MANUFACTURE table will have many manufacture columns with the same ID prefered_mfg_fk

when I pick the ---- 1:n icon

It will let me do a 1 to many prefered_mfg table 1 to the Manufacture table many

but does not let me do
a 1 Manufacture to Many prefered manufacture table

am I getting this wrong, should it me a 1:1