AnsweredAssumed Answered

Question joining tables then using lookup

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


Question joining tables then using lookup


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