Dec 07, 2022
Hello,I would like to create a database to manage my purchases and compare the prices of different suppliers.
I have products in one table and suppliers in another.I would like to have the possibility to enter a price for each new product created according to if it is proposed by the supplier.
I have created a linked record between the two databases but then I get stuck.Thank you for your help.
Dec 08, 2022
Hi Martin! As far as I understand, you want to enter your purchases in the Products table, and on entering it check the Suppliers table for containing the exact Product in order to enter a price for it? Correct me if I'm wrong!