Table Relationship Order
My database is currently laid out as pictured below. I have an order table that is related to a Order Detail table, Product table and Customer table. My Inventory table is related to my Product table as shown.
I would like to have a portal in my Production layout that shows inventory for each Order.
Is this possible with current configuration??