AnsweredAssumed Answered

Need help about finding error for my simple database

Question asked by leonhart1981_1 on Aug 3, 2015
Latest reply on Aug 4, 2015 by philmodjunk

Title

Need help about finding error for my simple database

Post

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~~~  

Relationship_4.png

Outcomes