AnsweredAssumed Answered

need help define relation

Question asked by tchung on Nov 16, 2012
Latest reply on Nov 19, 2012 by tchung

Title

need help define relation

Post

     need help on defining a relation for

     tableb
     fields: location, cust1, cust2, cust3, cust4
     with following data

     location | cust1 | cust2 | cust3 | cust4
     --------------------------------------------------
      a            | 08:00 | 08:30 | 08:40 | 09:00
      b            | 07:00 | 07:10 | 07:40 | 10:00
      ...           | ...         | ...         | ...       | ... 

     tablea
     fields: custname, location, time

     how to do a relation from table a to table b for time, so

     when tablea:custname=cust1 and tablea:location=a, field tablea:time auto populated with value of 08:00, or
     when tablea:custname=cust4 and tablea:location=a, field tablea:time auto populated with value of 09:00, or
     when tablea:custname=cust2 and tablea:location=b, field tablea:time auto populated with value of 07:10, and so for

     <enter>     | <enter>  | <auto from relation>
     custname | location | time
     ------------------------------------------
      cust1        | a             | <auto> 08:00
      cust4        | a             | <auto> 09:00
      cust2        | b             | <auto> 07:10
      ...     | ...      | ...

     thanks

Outcomes