AnsweredAssumed Answered

Question joining tables then using lookup

Question asked by cauchterlonie on Mar 3, 2009
Latest reply on Mar 4, 2009 by Jade

Title

Question joining tables then using lookup

Post

I have to tables and joined them using comparitive operaters.  Table #1 contains records with a time stamp field ("created date") while table #2 contains records with "start date" and "end date" (date fields).  The join is "created date" greater than "start date" and less than "end date". 

 

I then created a new look up field in Table #1 called "term"  I want to populate this field in Table #1 using the related field in Table #2 "term".  I set the new field up in Table #1 as a lookup field pointing to "term" in Table #2 - But no data is displayed in the new lookup field.  Any suggestions,  thanks

 

Chuck

Outcomes