Table Relationship and autofill??? question
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???