Depends... In the Netherlands two agents almost had a fist fight to represent me. They accompany you to all the interviews and prep you before the time.

I live in amsterdam and cycle to work, and when I use public transport its almost always excellent. If you think London has good public transport, your local public transport must be really bad.

Hi I need to edit the information in the child records

Hi Is it possible to display all child records of a datarelation and not just one at a time? I want a grid that the user doesnt have to open the child relation to see the contents, all parent and child records must be displayed. If not with the datagrid that comes with Visual Studio, any free controls that can? Thanks Izak :confused:

Thanks! If I understand it correctly, the customermaster and the inventorymaster creates all possible combinations except for the combinations in the NOT IN clause? So... If customermaster has 200 records and inventorymaster has 100 records and the salesdetal has 750 distinct records. 200 * 100 = 20000 - 750 = 19250, the result will have 19250 possible sales combinations that did not happen. Am my logic correct? Thanks again Eric, this has been very helpfull! :) Izak

Hi I want to create a report that lists the customers and all the items that they have not bought from us for a certain period. I have 3 relevant tables, CustomerMaster, InventoryMaster, SalesDetail. SalesDetail holds all the sale info, for example CustomerCode : 1AFR204 StockCode : FRA202 QtyInvoiced : 2 NetSalesValue: 1295 Year : 2006 Month : 7 The master tables holds all customers and inventory. I want the report to basicaly look like this: Ultra liquors Newton Park Not listed: Boland Cabernet Spier Sauvignon Blanc To be able to do this I need a recordset that consists of the stockcode and customercode of items not sold. Any ideas how to do this? I have been playing with not in subqueries. Its easy to display items not sold or customers that did not buy, seperately, but to combine them is a different animal. Thanks Izak

clear the datascource grdDetails.DataSource = Nothing

Hi I want to create a report in crystal reports (the one that comes with VS 2003) that reads its data from our SQL2000 server. The problem I have, is that it keeps on poping up the database login screen every time I try to run the report and then I have to enter the password. How do I remove the database login popup? Some extra information: 1. I have created a user in SQL Server 2000 with a password and the correct access rights to the tables that I want to read from. 2. In Crystal reports I created a connection with OLE DB (ADO) and entered the server, user ID, password and default database. Integrated security is not selected. Anyone have an idea what the problem might be? Thanks! Izak

Hi, Is it possible to remove the last line from the datagrid where you enter new row values (*) but still be able to edit the grid. Basically I want to be able to only edit the datagrid not add any rows to it. Thanks! :confused: