Hi Twitch
Is it ok too ask for a little more help, i have added the code as you shown me. Its working great, im now able too get info from 2 tables many thanks. Now i have a problem the search page (Index) as there is Type, Breed, Price from table (petdata) and Country, City from table (customerData). When i search any country or city it still just brings all records from the database. Also from the Results page i added a querystring too carry the info over to the Details page But its not workng? Thanks for any help Twitch, i have added the Index, Results and Details pages for you too look at if you can.