Linking Supplier to Manufacturers
I'm looking to link suppliers to manufacturers in our product database.
I've created a new table called supp_manu and created a serial number index called supp_manu_id.
The other fields I've created are supp_id and manu_id intended to link the supplier to the manufacturer and a discount filed to indicate the discount from the supplier in relation to the manufacturers product range.
I want to create a script/selection tool to allow the user to be able to be able to either link the supplier to the manufacturer from the manufacturer layout or the manufacturer to the supplier from the supplier layout without the user seeing the id index fields!
Any help would be grreatly appreciated!