AnsweredAssumed Answered

Relationship join table

Question asked by doorkitltd@gmail.com on Sep 22, 2014
Latest reply on Sep 22, 2014 by doorkitltd@gmail.com

Title

Relationship join table

Post

Hi

Can someone help me with this relationship?

I have a table called assembly where we are creating a quote for doors and frames.

The doors can have glass.  On the assembly I want to pick the glass and have it automatically populate the glazing seal and/or liner seals that are related to that glass. The glass available in the value list should be relatable to the fire rating of the assembly.

         
  1. I have created a join table for the glass/seal/liners
  2.      
  3. I have created a second instance of these for selecting the material on the assembly
  4.      
  5. And a third instance for the price.

I am only getting prices back for the first record in each table but only when I change the fire rating of the assembly.  So if I have more than 1 glass with different prices and different seals and liners it will only give the first in the list.

Untitled.png

Outcomes