Need help about finding error for my simple database
I made a simple database with following tables: customers, invoices, invoicelineitem and products.
The image below is the relationship diagram that I did.
I made this database because I want to test myself how much I am familiar with the relationship and the portal.
What I wan to accomplish is when I create an invoice, and type the item name in the portal, it should look up its price from the product table by itself and when I type the QTY in the portal, the stock availability in Product table should be reduced.
However, I think I must have done something wrong because when I did type the item name in the portal field, nothing happened. Here is the link for the video that I recording for reference.
If anyone know what I did wrong, please help me out~~~