AnsweredAssumed Answered

Table Relationship Order

Question asked by gjbdjc on Sep 16, 2014
Latest reply on Sep 16, 2014 by philmodjunk

Title

Table Relationship Order

Post

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

Relations.jpg

Outcomes