Link to home
Start Free TrialLog in
Avatar of Member_2_4426104
Member_2_4426104

asked on

how do i join info from 3rd table in my query?

Hi,
I have a form where I am entering dates/info from a training session.  
How do I have a text box display the duration from a distant table that is indirectly related to the one I am working with?

Right now the way I have set it up the only thing the text box displays is "3" for all records - which is the first result in the duration table.
 
Have attached screen shot of query.

Thanks.
Tania
query.jpg
Avatar of tigin44
tigin44
Flag of Türkiye image

if you add a non relational table to a query you should get a cross join... I think you want to do someting different than this.. Can you explain clearly  
ASKER CERTIFIED SOLUTION
Avatar of Member_2_4426104
Member_2_4426104

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial