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