How to manage these duplicates?
i'm stuck on what to do with these duplicates in the table supplier_product_line.
supplier - contains supplier detail, match to supplier_product_line as fk_supplier
product - contains the product, match to supplier_product_line as fk_product
supplier_product_line - no pk, connect supplier (fk_supplier) and product (fk_product)
- cost price
- net price
- date_modified - timestamp
Goal: Export and Show only the most up-to-date price of product per supplier
Problem: Should i be worried about duplicates in the table supplier_product_line? i tested it out and found that i can duplicate every supplier product without warning. is this the expected result? if that is the expected result, then if im going to export it, how to export only the most up-to-date price of a product per supplier?
thank you for the assistance!