Another very valid issue. Setting up a I don't know what I would call it, but a table like my orderdetails table that had multiple suppliers per product would be the best way to do it. Could even put the cost in that table so you could automate ordering via lowest cost with the mulitple suppliers.
I'd call it a Child Table ... but I expect there is a technical name for it!!
1 Like