AnsweredAssumed Answered

Data from one field to another field in a another table.

Question asked by kohlstech on Nov 8, 2016
Latest reply on Nov 8, 2016 by kohlstech

My First Table fields      DELIVERY 2016            

 

DC = (number)

Store = (Number)

Delivery Date = (Date)

Trailer Number = (Text)

 

My Second Table           DELIVERY DATA

Store = (Number)  Relationship to the First Table

 

Store6/86/96/10
1
2
3
4
5
6
7

 

what i am trying to do is the fields on table 2 6/8 6/9 6/10

in a calculation

 

match the store number in table 1 and show the trailer number that matches the Delivery date.

 

This is what i tried it the 6/8 Field

 

Case( DELIVERY 2016::Delivery Date = Date ( 6 ; 8 ; 2016 ); DELIVERY 2016::Trailer Number;"")

Outcomes