Hello all I try to build a query in access to get the entire device and line information in one list. I get the Device table and the NumPlan table from the publisher database. Now I have the entire device and the lines information. But I can't find a way to link them together. Is there a third table involve?? Thanks for help Reto