I have a load of products that I dispatch from a drop shipper.
what i want to be able to do is on the product admin, have an option to select from a drop down, the supplier (which will be stored in the db) and enter the suppliers reference for that product, and the suppliers url for that product.

what i've done in my MySQL db is create a new table called suppliers_info. The schema looks a bit like this:

supplier_id
supplier_name
supplier_website

this is a general list of each supplier. i will manually add the suppliers into the db at this stage, and worry about creating an admin section for this later.

i then have another table called products_suppliers
schema:

supplier_id
products_id
supplier_product_identifier
supplier_product_url

the first 2 columns are fairly obvious.
they relate to the product id, and supplier id (as in the supplier table)

the supplier_product_identifier column needs to contain the value from the produt admin page (need to add a new field) that the supplier uses to identify this product.
similarly, the supplier_product_url needs to be a new field on the products admin screen.

any ideas how i go about doing the above?