Hi. I'm a noobie in the MS Access world and I need a little help. I have 2 tables that look something like this: Customer - ID_customer (Autonumber) - Name - ID_respresentative Representative - ID_representative - Name_representative The relation between them is like this: a customer can have none, one or more representatives. A representative can represent only one customer at a time. How can I create a table that would show all the customers (the customers that have representatives and the ones that don't) and their representatives information. example: ID_cusomer | Name | ID_representative | Name_representative 1 | Customer1 | 1 | Representative1 1 | Customer1 | 2 | Representative2 2 | Customer2 | | 3 | Customer3 | 3 | Representative3 4 | Customer4 | | Any help would be greatly appreciated.