samantha

Grr! I have a unique identifier in my database (I defined it as unique by: 'define fields, options, validation, select unique tick box). It works fine for data entry (i.e. say's I'm not allowed to duplicate id's in that field). But when I'm importing data, it'll allow my 'unique' field to have duplicate's in! Aargh! It took me hours yesterday to make sure that the right person had been allocated to the right company, as around 14 company's shared 'unique' id's!! Consequently, I have no faith that the right people are married up to the correct organisation. Does anyone know how to make the unique field option really work?! thanks A very frustrated Sam!

Brilliant, thankyou! One question - can I search for a weeks time, but leave it flexible? in other words, I want to look for today + 7. Is this possible? Thanks Sam

I'm trying to do a search on a date range, but it needs to be flexible. I have a list of end dates, and each week I would like to be able to run a script that returns projects that are due to end in the next week. I wouldn't have thought it would be too dificult, but I just CANNOT make it happen, with a find or script or anything! Help! Thanks Sam