AnsweredAssumed Answered

Table Relationship and autofill??? question

Question asked by gjbdjc on Aug 25, 2014
Latest reply on Sep 4, 2014 by philmodjunk

Title

Table Relationship and autofill??? question

Post

     I have a database with an "ORDERS" table which links to both a "ORDER DETAILS" table and a "PRODUCTS" table as shown in diagram.  Within the ORDER DETAILS layout, I want to show Equipment that is specific to the PRODUCT.  Each equipment combination has a code, such as RJ 30 (as shown). I would like the equipment specifics fields to "auto-populate" when the code is selected??? 

Equip.jpg

Outcomes