How to Apply SQL Relational Database Design to Excel | Create an Excel Order Management System

[@osoriomatucurane9511]

Awesome tutorial, crystal clear and concise. I have strugling to understand the relationship between the order and order_items table. I cant take you enough for such wonderful tutorial. Keep it up.

[@UtkarshSinha-w4h]

Hey! Could you please explain why you didn't VLOOKUP the Unit Price?

[@johnnycode]

The Unit Price in the Order Details table should be a "snapshot" of the price at the time of the order. That is the price the customer paid and should never change. You should not use VLOOKUP because if you decide to change the price in the Products table in the future, it will change the prices in the Order Details table and your order history will not be accurate anymore.

[@osoriomatucurane9511]

This is excellent. It is a great tip. I have experienced this e I did not know how to work it arround.

[@RajDilip-m6x]

I did follow all steps and created a new file but in the end its not complete as these orders do get fulfilled and then they need to hidden or removed from the orders page. I guess it would be better to just move this data to another sheet where old records get maintained and maybe in future we could work on a dashboard. This is getting very interesting. Thank you for such great and informative video ❤

[@johnnycode]

A dashboard is a good idea. I don't have a video on that, but my other videos might give you some inspiration: In my Autofill Invoice video, you can see how to use VBA to bring data into another sheet: kzbin.info/www/bejne/jqXGm4toost-grs In my Compare List video, you can see how to use Power Query to join tables, so you can join Orders x Customer x Products x Product Details: kzbin.info/www/bejne/oHy0YYyubbd9fdk

[@johnnycode]

If you're interested in taking the Orders data and autopopulating an Invoice template: kzbin.info/www/bejne/jqXGm4toost-grs

[@RajDilip-m6x]

Please provide a link to download this sample file. Thank you❤

[@johnnycode]

Thanks for your interest, I uploaded the files here: github.com/johnnycode8/excel_vba_power_query