twinturbo

Thanks for your help, I'll have a go at getting that working and see how it goes. Regards Paul

This was the only way I could think of also, although I couldn't really get my head around how to do it, considering I will have thousands of call records per month to manage I was concerned about efficiency. If I could be sure how many numbers always followed the area code it would certainly be easier, but I'm not. Regards Paul

Well the only way yo tell is by looking at the actual phone number, for example a number for the US might be 1875557849 so the prefix is 1, but another number might be 6489024573, but in this case the first 2 numbers might be for the generic country code (I think NZ), but there could also be another match which might be 6489 for a NZ mobile (all fictitious of course -) so you see I can't actually know whether the prefix is 1 digit or 6, but it can be anything in between I know that. Regards Paul

Hi All, I am working on a database which reads call records from a pabx and splits them with associated costs to separate people. I have one table callrecords which holds all the records, the only thing I need from there is the duration and destination number. To determine the charge for the call I need to lookup the call rate from my rates table which defines the prefix for the number and the rate to charge for the prefix. My problem is that I want to setup a relationship to do this lookup of the call rate, but, different countries have different prefixes, for example US is 1, but Finland is 358, Germany/Dusseldorf is 49211, how on earth can I match the call rate records in my rates table with prefixes from the callrecords table when the number of characters varies from prefix to prefix ? Any suggestions would be greatly appreciated, I have been looking for some answers for this for some time. I have considered a calculated field for the relationship, but I will still have the problem of never really knowing the prefix which has been used for each call record. Regards Paul

Hi Folks, I have a problem with trying to close a report window shown to a user in a runtime solution because the X is dimmed out. Apparantly you can't close windows in Runtime solutions, so to fix it I will just pause the script running the report, then when the user hits the continue button I will continue the script and close the window. That's all fine, but how can I hide the Cancel button from the status area so the user doesn't invariably hit that and muck everything up ? Any ideas ? Thanks heaps Regards Paul