Hi, I am working with a database i have not created and trying to improve on. the database has all customer details in it the tables include contacts, farm description, permits etc i also now have a table which contains all of this data. and have a query as well. what i need though is a report which will give me all details of the customer ie contacts, each farm owned (which can be 3 or 4) each permit for each farm (may be 2 or 3). i have tried various different ways of inputing the data but it wont collate all farms and permits to one customer. need help - going crazy!!!